Carousell Interview Question

SQL question to write query with joins