Evertz Microsystems Interview Question

First interview they asked me some basic coding problems which were easy to medium level. They asked me some Linux questions and some of its commands and at the end after asking all of these questions they made me write a sql query for which they had provided me with the question