MediaAgility interview question

SQL query for a particular real.world scenario