Learn SQL
Learn SQL by actually writing SQL code
Table of Contents

12DISTINCT operator

16COUNT & DISTINCT

19Select multiple data

29Combining data from columns

30GROUP BY - with COUNT

31GROUP BY - with other aggregate functions

33GROUP BY - multiple columns

34GROUP BY - GROUP_CONCAT

37JOINS - Filtering and Ordering

38JOINS - Grouping

39JOINS - Complex grouping

42INTERSECT and EXCEPT

44Subqueries in FROM clause

49Executing multiple statements

51Column constraints - DEFAULT and CHECK

53PRIMARY KEY - AUTOINCREMENT

54Table constraints - FOREIGN KEY

58Renaming and deleting tables