We continue working with functions and have introduced aggregate functions. We have also started adding logic to queries using CASE clauses.
CASE WHEN condition1 THEN action1 WHEN condition2 THEN action2 -- more conditions + actions ELSE escape_action END
Download the class notes for day 4.