The Art of PostgreSQL/

...

/

Discover the Data Model

Discover the Data Model

Learn about querying the records in the Million Songs dataset using PostgreSQL.

We'll cover the following...

Time to discover the data model and the data itself with the first batch of interactive queries, with the sole aim of fulfilling our curiosity:

Press + to interact
  select artist, count(*) 
    from lastfm.track
group by artist
order by count desc 
   limit 10;

We can see that one of the most popular artists in the dataset is Aerosmith:

           artist            │ count 
═════════════════════════════╪═══════
 Mario Rosenstock            │    13
 Aerosmith                   │    12
 Snow Patrol                 │    12
 Phil Collins                │    12
 Sugar Minott                │    11
 Bill & Gloria Gaither       │    11
 Line Renaud                 │    11
 Shakira                     │    11
 Radiohead                   │    11
 Nick Cave and the Bad Seeds │    11
(10 rows)

Now, let’s have a look at the kind of tags this artist would ...