SQL-Tasks

Task 1: WHERE

Task 2: BETWEEN and IN

Task 3: LIKE and ILIKE

Task 4: DISTINCT and COUNT

Task 5: ORDER BY, LIMIT and OFFSET

Task 6: Aggregate Functions

Task 7: GROUP BY, HAVING

Task 8: CREATE, DROP, UPDATE, DELETE

Task 9: INNER JOIN

Task 10: LEFT, RIGHT AND FULL JOIN

Task 11: UNION, INTERSECT, EXCEPT

Task 12: Query Scenarios and Subqueries