I do a lot of data analysis lately, and I try to find answers to
questions through data for my companies pressing questions. Let's
look at the past year of 2017 and answer questions for people who
like music.
artist is the artist name
track is the artist's track name
list_date is which chart date the artist show up on the
top200
streams is the number of plays following spotify specific
rules
Let's look at the data set
select count(*) from spotify.top200 WHERE country='us' and
list_date >= '2017-01-01' and list_date <
'2018-01-01';
+----------+
| count(*) |
+----------+
| 74142 |
+----------+
1 row in set (0.04 sec)
How many artists made it in the top200 for the United
States?
mysql> select count(DISTINCT(artist)) from spotify.top200
WHERE …
