Clifford Chance interview question

Write sql queries for between function, group by clause, count rows. For each, a problem statement was give