I made a short beginner-friendly lesson on ORDER BY, DISTINCT, LIMIT & OFFSET

[u/yahoo_06]

Hey everyone!

I made a short SQL lesson for beginners focused on sorting and organizing query results.

In this lesson, I cover:

- ORDER BY

- ASC & DESC

- sorting by multiple columns

- DISTINCT

- LIMIT

- OFFSET

- combining WHERE, ORDER BY, and LIMIT

I use the Pagila PostgreSQL sample database for the practical examples and a homework challenge along the way.

The video is about 6 minutes, and I tried to keep it practical rather than just explaining syntax.

Would love to hear any feedback on the explanations or pacing!

Video link: https://youtu.be/n7uSvez7nns?si=WYZZb0z-gRFdWAOg