Confluent Interview Question

Design a database and sql query based on the database designed