Gravitas interview question

Questions regarding SQL queries were there