Pergunta de entrevista da empresa Clearwater Analytics (CWAN)

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