NiCE interview question

Very basic SQL queries