Sollicitatievraag bij Clearwater Analytics (CWAN)

How would you design a SQL query given a specific dataset and a specific question.