CREATE TABLE song (f_id VARCHAR(255), formats VARCHAR(255), resolution INTEGER); CREATE TABLE files (f_id VARCHAR(255), formats VARCHAR(255), resolution INTEGER)
Find the id of songs that are available in mp4 format and have resolution lower than 1000.
    
SQL: SELECT f_id FROM files WHERE formats = "mp4" INTERSECT SELECT f_id FROM song WHERE resolution < 1000