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 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
You need to sign up for Treehouse in order to download course files.Sign up