Artist maxranks
Trailing by two: should we go for two or three?
Two-sample t-test
Trailing by two: should we go for two or three?
Two-sample t-test
SQL
Easy
Assume the following schema:
artist along with maxRank, title, and whether the artist is a remixer. The result should only contain rows with maxRank greater than 50.
Order the result by artist in increasing order, and limit your response to 4 rows. The results should look like the following:
| artist | maxRank | title | remixer |
|---|---|---|---|
| 1467 | 92 | 30 Years At Sea | False |
| 4432 | 68 | 2soul | True |
| 10297 | 97 | Fusion Love | True |
| 12649 | 59 | The Clown feat. Pedestrian | False |
We can join tables
charts and songs and artist_songs to get all the information we need:
SELECT distinct artist, maxRank, title, remixer
FROM charts t1 INNER JOIN songs t2
ON t1.trackid = t2.trackid AND t1.maxRank > 50
INNER JOIN artist_songs t3 ON
t2.trackid = t3.trackid
order by artist
limit 4| artist | maxRank | title | remixer |
|---|---|---|---|
| 1467 | 92 | 30 Years At Sea | False |
| 4432 | 68 | 2soul | True |
| 10297 | 97 | Fusion Love | True |
| 12649 | 59 | The Clown feat. Pedestrian | False |
Join
- Expensive house songs II Hard (Subquery, CTE, Join, Window functions)
- Expensive house songs I Medium (Subquery, CTE, Join)
- Songs that did not enter the charts or entered high Medium (Subquery, Join)
- Histogram of songs Hard (Recursive CTE, Join)
- Songs in charts with greater durations Hard (Subquery, CTE, Join, Window functions)
Thank you, we have received your feedback.