Pregunta de entrevista de Buck

Basic SQL some queries based on group by and joins