1
00:00:00,380 --> 00:00:05,570
In this stage, we've ordered our results
by ascending and descending orders using

2
00:00:05,570 --> 00:00:11,030
the order by ASC and DESC keywords.

3
00:00:11,030 --> 00:00:14,470
We've ordered results with
multiple column criteria,

4
00:00:14,470 --> 00:00:17,320
separating each order
criteria with a comma.

5
00:00:18,905 --> 00:00:22,610
We've limited our results
set with the limit keyword.

6
00:00:22,610 --> 00:00:24,690
Limit comes at the end of any query.

7
00:00:25,730 --> 00:00:31,020
Finally, we skipped over rows for
paging purposes using the offset keyword.

8
00:00:31,020 --> 00:00:35,490
We also learned that there's
a shorthand format for this syntax too.

9
00:00:35,490 --> 00:00:39,680
Go ahead and launch the SQL Playground
with this video, because it's now time for

10
00:00:39,680 --> 00:00:41,930
you to practice what you've learned.

11
00:00:41,930 --> 00:00:44,180
Open the SQL Playground
with this video and

12
00:00:44,180 --> 00:00:46,785
familiarize yourself
with the database schema.

13
00:00:48,330 --> 00:00:52,360
In the coding sections at the top left
here, I've presented SQL challenges for

14
00:00:52,360 --> 00:00:53,960
you to tackle.

15
00:00:53,960 --> 00:00:58,590
For example in this coding area I've
included SQL comments asking you to

16
00:00:58,590 --> 00:01:02,320
order movies from the movies
table by the year released.

17
00:01:03,710 --> 00:01:06,770
Once you're done practicing,
head over to the next assessment and

18
00:01:06,770 --> 00:01:08,000
I'll see you on the other side.