Pregunta de entrevista de Saviynt

SQL question based on joins, group by and having