How many songs have a resolution below 800?
select count ( t2.song_name ) from files as t1 join song as t2 on t1.f_id = t2.f_id where t2.resolution < 800
What are the file sizes of those songs?
select t1.file_size from files as t1 join song as t2 on t1.f_id = t2.f_id where t2.resolution < 800
What are the formats for the songs with a resolution below 800?
select t1.formats from files as t1 join song as t2 on t1.f_id = t2.f_id where t2.resolution < 800