This exercise assesses SQL skills. It also assesses the ability to interpret data models, interpret questions, attention to detail and data wrangling.
This is a free practice Alooba World exercise. For the SQL exercise you will need to write SQL queries which will be validated against a database.
Your query output will be compared with the expected output for the question. You will be awarded full marks if the output matches the expected output, and 0 marks if it doesn’t match. The outputted column names are not considered, only the order of the outputted columns. Ensure you read the question thoroughly and provide the output expected.
Ensure you execute your query and check the output before submitting. You may execute your queries as many times as needed. The database will be reset to its initial state before each execution.
The exercise lasts for 6 minutes and contains 1 question.
This exercise is designed to be completed on a desktop or laptop.
You will complete your details on the next page and receive the unique link via email.
Best of luck!
Your queries will be executed using a database engine which is compliant with the majority of basic SQL syntax. Ensure your queries use ANSI SQL. You cannot use any database specific functions or syntax.
A few points when writing your queries:
Looking to assess your team or candidates? Reach out to us to find out how.