What's the rating of all songs in English?
select rating from song where languages = 'english'
What are the names of all the songs?
select song_name from song
Which of those have rating below that of all songs in English?
select song_name from song where rating < ( select min ( rating ) from song where languages = 'english' )