Basic Queries

ORDER BY

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:

1. The data should include the species_ID, year, and the weight. These columns should be presented in this order.
2. Individuals should be sorted in descending order with respect to mass.
3. Since individuals often have the same mass, ties should be settled by sorting next by hind foot length and finally by the year of capture.

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.

[click here for output]