Lecture 02: Aggregation and JOINs

Lecturer

Janus Valberg-Madsen <janus@math.aau.dk>

Time

Mar 25, 08:15-12:00

Place

Skjernvej 4A, room 2.120

Contents of lecture

• Aggregating/summarising data
• JOINs
• Subqueries

Exercises

• SELECT within SELECT [solutions] (+quiz)
• SUM and COUNT [solutions] (+quiz)
• JOIN [solutions] (+quiz)
• Using NULL [solutions] (+quiz)

Extra exercises [solutions]

Literature and resources

• Slides
• [Docs] Chapter 9, Functions and Operators, section 20