English subtitles

← More Join Practice - Intro to Relational Databases

Get Embed Code
4 Languages

Showing Revision 3 created 05/24/2016 by Udacity Robot.

  1. Okay, so here are two other
    tables in the zoo database.
  2. The first one, taxonomy,
    gives the scientific names for
  3. all our animal species.
  4. We've been using the common names
    like brown bear in our other tables.
  5. This table gives not quite the full
    taxonomic name but a lot of it.
  6. The brown bear is genus Ursus.
  7. Species arctos.
  8. And the family Ursidae.
  9. And the oder Carnivora.
  10. We have to call this column
    t_order instead of order,
  11. because order is a reserved
    word in SQL for order buy.
  12. The t is for taxonomy.
  13. And if we look in this table over here,
    we'll see the common names for
  14. all of the orders.
  15. Bats belong in the order Chiroptera and
    lizards and
  16. snakes belong to the order Squamata.
  17. and llamas and moose and warthogs all
    belong to the order Artiodactyla.
  18. Okay, okay, so
  19. really these tables are just here
    to give you more stuff to join.
  20. Big surprise.
  21. This time we want to find out which
    orders have the most individual animals
  22. in the zoo, and we want to give
    their common names like monotremes,
  23. instead of their scientific
    names like monotremata.
  24. So you'll probably need to use both
    of those tables, the taxonomy and
  25. the order names table, plus the animals
    table with the individual animals in it.
  26. So the problem is, to list the taxonomic
    orders by their common names,
  27. sorted by how many individual animals
    we have of each order in the zoo.
  28. To see the full schemas the tables,
    take a look at the instructor notes.