Pregunta de entrevista de 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.