Check out a free preview of the full SQL Fundamentals course:
The "LIMIT and ORDER Exercise" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:
In the example app, the orders page has over 16,000 records. This large amount of data is too much data to show to users all at once. Even looking at an individual customer’s orders is a bit overwhelming. In this exercise, students use the existing user interface for sorting and pagination, and modify the “orders list” and “customer orders list” queries as appropriate.