Higher DDD - Testing & Evaluation
Presentation
•
Computers
•
9th Grade
•
Practice Problem
•
Easy
G Alexander-Doyle
Used 5+ times
FREE Resource
10 Slides • 1 Question
1
2
3
4
5
6
7
8
9
Open Ended
A swimming club uses a database to store details of swimmers and their times in a 50 meters swim. A sample of the data stored in the Swimmer table is shown below.
The head coach would like to produce a report displaying the slowest and fastest times from any of the squads with a ‘1’ in their name, as shown below.
The following SQL statement is executed.
SELECT squad, MIN(time) AS [Slowest Time], MAX(time) AS [Fastest Time] FROM Swimmer WHERE squad LIKE "1"
When tested, the actual output did not match the expected output. Identify the three errors in the above SQL statement. (3 marks)
10
11
Show answer
Auto Play
Slide 1 / 11
SLIDE
