Amazon Interview Question

Basic SQL questions involving joins, Aggregate functions and window functions