Give interview question

SQL queries on join