YouTube interview question

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