Pregunta de entrevista de Confluent

Design a database and sql query based on the database designed