Preview
Video Player
00:00
00:00
Practice Session
1:08Let's practice what we've learned in this section.
In this stage, we've ordered our results
by ascending and descending orders using
0:00
the order by ASC and DESC keywords.
0:05
We've ordered results with
multiple column criteria,
0:11
separating each order
criteria with a comma.
0:14
We've limited our results
set with the limit keyword.
0:18
Limit comes at the end of any query.
0:22
Finally, we skipped over rows for
paging purposes using the offset keyword.
0:25
We also learned that there's
a shorthand format for this syntax too.
0:31
Go ahead and launch the SQL Playground
with this video, because it's now time for
0:35
you to practice what you've learned.
0:39
Open the SQL Playground
with this video and
0:41
familiarize yourself
with the database schema.
0:44
In the coding sections at the top left
here, I've presented SQL challenges for
0:48
you to tackle.
0:52
For example in this coding area I've
included SQL comments asking you to
0:53
order movies from the movies
table by the year released.
0:58
Once you're done practicing,
head over to the next assessment and
1:03
I'll see you on the other side.
1:06