For this exercise, any code samples should be written in SQL. The candidate can assume that there is already a database setup with the appropriate connections, etc. We’re simply asking for the schema definitions and some SQL queries.
If you have any questions or clarification about the prompt, please make your best educated guess about what the business case might be asking for and make note of those assumptions. The exercise is intended to be open to interpritation, so there is no one correct solution to strive for. Follow-up conversations around your decisions & assumptions will be more valuable than the code itself, so feel free to be describe your thoughts as you're going along.
Company X runs a factory producing customizable widgets. There are four variations of widgets that can be ordered. Each widget, regardless of variation, must go through the same three processing steps. Each processing step is done by hand by a variety of operators on the factory floor. For the purp