List all the durations of the songs.
select duration from files
How many are there if the duration is 4 mins?
select count(*) from files where duration like "4:%"
What are the names of those songs?
select t2.song_name from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.duration like "4:%"
What about the song names which has 4 minute duration or is in English?
select t2.song_name from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.duration like "4:%" union select song_name from song where languages = "english"