Multiple tables: Grouping songs

  1. Import songs
  2. Multiple tables
  3. Joining tables

Now that we have songs, we can look up, for example, how many songs we have in each genre.

select genre, count(*) as songcount from songs group by genre

We can do everything in this table that we could in the other one, just on different data.

  1. Import songs
  2. Multiple tables
  3. Joining tables