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 using aggregate functions.
Motivation: A good programmer should be skilled at using aggregate functions when interacting with databases.
Select all queries that return number of students whose first name is John.
TABLE student id INTEGER NOT NULL PRIMARY KEY firstName VARCHAR(30) NOT NULL lastName VARCHAR(30) NOT NULL