Scale Interview Question

SQL question on a business case