Studio71 interview question

Set up a SQL database with XYZ information. Explain each items relationship. Query the database for specific information.