YouTube Interview Question

Can you write a SQL query for me based on this available data?