Coolbet interview question

SQL - Join, Filter, Group by query.