Pergunta de entrevista da empresa Ocean Finance

Asked a complex SQL question where it was expected that the answer, one with several CTEs, be written in a word document within 15 minutes.