Pregunta de entrevista de SAIC

Different between some data structures. write a query with join conditions.