Pregunta de entrevista de Gupshup

SQL Query Count, Where condition,Order by and join