Walleye Capital interview question

Write a complex SQL query involving joins and coalesces