Confluent interview question

Design a database and sql query based on the database designed