Numerator Interview Question

Questions based on SQL (Joins, Rank). Data Visualisation Question