Songs that did not enter the charts or entered high
SQL MediumAssume the following schema:
| Number of songs |
|---|
| 4845 |
There are several ways to answer this question, perhaps the easiest one is to use a left join and then filter on NULL as follows:
SELECT count(*) as 'Number of songs'
FROM songs t1 LEFT JOIN charts t2
ON t1.trackid = t2.trackid
where maxRank is Null or maxRank > 90;| Number of songs |
|---|
| 4845 |
Alternatively, we can use a subquery:
SELECT count(*) as 'Number of songs'
FROM songs t1
WHERE t1.trackid NOT IN
(SELECT DISTINCT trackid FROM charts WHERE maxRank <= 90)| Number of songs |
|---|
| 4845 |
Subquery, Join
Similar questions
- Histogram of songs Hard (Recursive CTE, Join)
- Expensive house songs II Hard (Subquery, CTE, Join, Window functions)
- Expensive house songs I Medium (Subquery, CTE, Join)
- Songs in charts with greater durations Hard (Subquery, CTE, Join, Window functions)
- Artists with more songs than others Hard (Subquery, CTE, Join, Window functions)