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.