Viasat interview question

How would write this SQL query? What is the size/ columns of the table?