Altice interview question

SQL queries (Group by, Join etc.)