Arcadia.io interview question

Tech / Systems Designs interview involved mapping out a SQL database using several tables with Primary Key relations. Was then asked to query the database that was built. Core SQL competencies were sub-queries, GROUP BY and ORDER BY. Pretty easy stuff.