Informed interview question

SQL queries and joins.