Marsh Interview Question

SQL queries on a scenario.