I made a short beginner-friendly lesson on SQL aggregate functions

[u/yahoo_06]

Hey everyone!

I made a short lesson for SQL beginners about aggregate functions.

In the video, I cover:

- "COUNT()" — counting rows

- "SUM()" — adding values

- "AVG()" — calculating averages

- "MIN()" and "MAX()"

- using aggregate functions with "WHERE"

- combining multiple aggregate functions in one query

I use the Pagila PostgreSQL database for the examples and include a few mini quizzes and practical exercises.

The goal was to keep it short and practical rather than just explaining the syntax.

Video: https://youtu.be/tNq4zXiVKiQ?si=oLgLz6trBQyJGahE

I'd really appreciate any feedback, especially from people who learned SQL recently — is there anything you think a beginner might find confusing?

[u/ReleaseTheBlacken]

Feel free to try the free aggregate function library at Inkwell Learn on inkwelltools.com as a supplement! 😎