Question

14. Get the total number of countries where the subscribers of the Taylor Swift channel (channel_id = 399) are present.

Expected Output Format

country_count

Answer 1

SELECT COUNT(Countries)
FROM songs
WHERE title IN
    (SELECT genre
     FROM artists
     WHERE genre LIKE "pop");