Pergunta de entrevista da empresa Walleye Capital

Write a complex SQL query involving joins and coalesces