Return the names of songs for which the format is mp3 and resolution is below 1000.
select t2.song_name from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.formats = "mp3" intersect select song_name from song where resolution < 1000
Yes
select t2.song_name from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.formats = "mp3"
What is the resolution for song name "Just beat it"?
select resolution from song where song_name = "Just beat it"
Please show me the names of songs for which the format is mp4 and resolution is below 1000.
select t2.song_name from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.formats = "mp4" intersect select song_name from song where resolution < 1000
Can you show me the resolution for song name "Aj ei Akash"?
select resolution from song where song_name = 'Aj ei akash'
Can you please show me the song name with highest resolution?
select song_name from song order by resolution desc limit 1
And what was the resolution for this song name?
select resolution from song where song_name = 'Tumi robe nirobe'