Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Practice Session1:08 with Andrew Chalkley
Let's practice what we've learned in this section.
In this stage, we've ordered our results by ascending and descending orders using
the order by ASC and DESC keywords.
We've ordered results with multiple column criteria,
separating each order criteria with a comma.
We've limited our results set with the limit keyword.
Limit comes at the end of any query.
Finally, we skipped over rows for paging purposes using the offset keyword.
We also learned that there's a shorthand format for this syntax too.
Go ahead and launch the SQL Playground with this video, because it's now time for
you to practice what you've learned.
Open the SQL Playground with this video and
familiarize yourself with the database schema.
In the coding sections at the top left here, I've presented SQL challenges for
you to tackle.
For example in this coding area I've included SQL comments asking you to
order movies from the movies table by the year released.
Once you're done practicing, head over to the next assessment and
I'll see you on the other side.
You need to sign up for Treehouse in order to download course files.Sign up