ORDER BY (Basic Queries)
The graduate students that work at the Portal site are hanging out late one evening drinking… soda pop… and they decide it would be an epically awesome idea to put together a list of the 100 largest rodents ever sampled at the site. Since you’re the resident computer genius they text you, and since you’re up late working and this sounds like a lot more fun than the homework you’re working on (which isn’t really saying much, if you know what I’m saying) you decide you’ll make the list for them.
The rules that the Portal students have come up with (and they did spend a sort of disturbingly long time coming up with these rules; I guess you just had to be there) are:
- The data should include the
species_id,year, and theweight. These columns should be presented in this order. - Individuals should be sorted in descending order with respect to mass.
- Since individuals often have the same mass, ties should be settled by
sorting next by
hindfoot_lengthand finally by theyear.
Since you need to limit this list to the top 100 largest rodents, you’ll need to
add the SQL command LIMIT 100 to the end of the query. Save the final query as
100_largest_individuals.