Barclays interview question

SQL queries for JOIN, GROUP BY, ORDER BY, etc.