Question d’entretien chez Clearwater Analytics (CWAN)

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