Amazon Interview Question

SQL queries simple and basic