Practice · Art & Cinema · Easy

The music greats

Return the name and birth_year of every cultural figure whose domain is music, earliest-born first.

Runs in your browser. No signup needed.

What you are given

cultural_figures(name, domain, birth_year, death_year). domain is cinema / music / art.

Starting point

SELECT name, birth_year
FROM cultural_figures
WHERE domain = 'music'
ORDER BY birth_year;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.

Did you know

Umm Kulthum, the "Star of the East", so defined Arab music that her Thursday-night radio broadcasts reportedly emptied the streets of Cairo. (Britannica)

More Art & Cinema challenges

Open it in the playground →