Tiger Analytics Interview Question

Basic SQL joins, group by, windows functions.