IBM Interview Question

Asked about the SQL queries in the interview