Pregunta de entrevista de GSK

(Online assessment) Write a SQL query using GROUP BY, INNER JOIN, and SORT BY