Testing and evaluation

When testing queries, it is good practice to document expected results and actual results. A comparison can then be made, with testing passed if the expected result and actual result is the same.

In the example shown below, the design and implementation (SQL) are also shown to provide a clear context for the testing that follows.

The query being tested is designed to run on the data held in the following versions of the pupil and orchestra tables.

Pupil table

Orchestra table