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 joining data from multiple tables.
Motivation: Most of the queries into a normalized database require joining data from multiple tables.
Information about pets is kept in two separate tables:
TABLE dogs id INTEGER PRIMARY KEY, name VARCHAR(50) NOT NULL TABLE cats id INTEGER PRIMARY KEY, name VARCHAR(50) NOT NULL
Identify all the queries that select all distinct pet names.