This repo contains solutions to the exercises, presented on the website http://www.sql-ex.com.
These are SQL statements for retrieval or modification of specific data.
Topics covered by the exercises:
- simple SELECT, INSERT, UPDATE, DELETE statements
- INNER and OUTER JOIN operations
- UNION, INTERSECT and EXCEPT operations
- predicates: trinary logic; SOME, ANY, ALL, EXISTS, LIKE, IN, NOT IN
- subqueries (uncorrelated and correlated), WITH statement
- GROUP BY and HAVING clauses, aggregate functions
- CASE statement