IVP Interview Question

SQL queries for a particular scenario.