SAIC Interview Question

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