Coolbet Interview Question

SQL - Join, Filter, Group by query.