SQL Test

Basic schema

Please use the above schema for all questions below. Since you are not expected to test the code, minor syntax errors will be tolerated.  You will have 30 minutes to complete the test, from the time you receive the link via email to submission time (recorded upon clicking Submit button).  Any submissions after this time will not be accepted. The test has no automated timer, so please track your time carefully.