Pregunta de entrevista de Vena Solutions

Proficiency in SQL and walk through an example problem and how I would sort it out in SQL