From the course: MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Solution: The ORDER BY clause

Solution: The ORDER BY clause - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: The ORDER BY clause

“

- [Instructor] All right, here's the Solution Video for the ORDER BY Assignment. As a reminder, your business partner, Uncle Jimmy, is looking for film titles with their lengths, their rental rate, and he wants them sorted in order of length descending. You'll need to use ORDER BY. Let's jump into Workbench and walk through the solution. All right, so first step per usual, I'm going to go up and look in the Tables and try to figure out what we need to work with. So, I know we're looking for film data. It could be film, it could be inventory, possibly, so we'll take a look at film, see what columns we have to work with. We need title, we need length, and we need rental rate. So, film table is what we want to work with. So, we'll go into that. So, first I'm running my SELECT star just to see the data that's in there. So, we have title, yep, confirmed, that's what Uncle Jimmy is looking for. And we have rental rate and we have length, which appears to be in minutes. So, now we'll get…

Contents