Provide all the details of the song Tumi robe nirobe?
select * from song where song_name = "Tumi robe nirobe"
What are the maximum and minimum resolution of songs whose duration in 3 minutes?
select max ( t2.resolution ), min ( t2.resolution ) from files as t1 join song as t2 on t1.f_id = t2.f_id where t1.duration like "3:%"
List the songs with size more than 4MB ?
select * from files as t1 join song as t2 on t1.f_id = t2.f_id where file_size > 4