What are the minimum, maximum and average values of the ratings?
select min(rating), max(rating), avg(rating) from song
Which songs have a higher rating than the average, list the song names.
select song_name from song where rating > (select avg(rating) from song)
What about the names which rating is higher than the rating of all songs in English?
select song_name from song where rating > (select min(rating) from song where languages = 'english')
How about lower?
select song_name from song where rating < (select min(rating) from song where languages = 'english')