Warner Bros. Discovery interview question

SQL Queries from some online