Find the distinct names of all the songs that have a higher resolution than some songs in English, please?
select distinct song_name from song where resolution > ( select min ( resolution ) from song where languages = "english" )
What countries are those songs from?
select country from song where resolution > ( select min ( resolution ) from song where languages = "english" )
Can you add the songs' names and resolutions to the table?
select country,song_name, resolution from song where resolution > ( select min ( resolution ) from song where languages = "english" )
What are the names of the top 3 rated songs?
select song_name from song order by rating desc limit 3
Could you add the artists' names to the table?
select song_name,artist_name from song order by rating desc limit 3