Vena Solutions interview question

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