Frage im Vorstellungsgespräch bei Clifford Chance

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