The testing process: Selecting queries which correctly perform a given task.
Motivation: SQL is the dominant technology for accessing application data and is more and more becoming a performance bottleneck when it comes to scalability.
The testing process: Analyzing database queries containing complex conditions.
Motivation: When querying a database, it's a general best practice to retrieve the minimum amount of information you need.
A table containing the enrollment year has incorrect data in records with ids between 20 and 100.
Select all queries below that, for the faulty records, set the year to 2015.