Here is a SQL exercise based on the 2022 SQL exam set by Dr C Kader and moderated by Mr T de Jager and Mr R Viljoen of the IEB Pretoria 480 cluster.

In some cases you may find comments which can be annoying if you print the documents shown below. These can be turning off in Ms Word, under Review, Tracking, Show markup, and then un-tick the boxes.

Download the exam paper here

Download the Ms Access database here – (DecorDB.mdb) – remember to “Enable Content”

Download the memo here

Additional questions are here

SQL tips and traps when answering an exam paper