Pregunta de entrevista de PayU

Write queries in MySQL. Questions were based on join and Group By.