We have covered basic SELECT statements joining (INNER|LEFT|RIGHT JOIN) multiple tables, filtering data (WHERE) and organizing the output (ORDER BY) as well grouping values (GROUP BY) when using aggregate functions. Now we are having fun with SQL.
Download the class notes for day 3.