SELECT f_id FROM files WHERE formats  =  "mp4" INTERSECT SELECT f_id FROM song WHERE resolution  <  1000
Find the id of songs that are available in mp4 format and have resolution lower than 1000.
SELECT f_id FROM files WHERE formats = `` mp4 '' INTERSECT SELECT f_id FROM song WHERE resolution < 1000
select f_id from files where formats = value intersect select f_id from song where resolution < value
Find the id of songs that are available in mp4 format and have resolution lower than 1000 .