Question d’entretien chez Walleye Capital

Write a complex SQL query involving joins and coalesces