Meta interview question

SQL with joins, Basic Probability, general approach to KPI