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 subqueries.
Motivation: Subqueries are commonly used in database interactions, making it important for a programmer to be skilled at writing them.
Given the following data definition, select all queries that return a list of employees who are not managers.
TABLE emp id INTEGER NOT NULL PRIMARY KEY mgrId INTEGER REFERENCES emp (id) name VARCHAR(30) NOT NULL