12 marks
A database table, PERFORMANCE, is used to keep a record of the performances at a local theatre.
ShowNumber | Type | Title | Date | SoldOut |
|---|---|---|---|---|
SN091 | Comedy | An Evening at Home | 01 Sept | Yes |
SN102 | Drama | Old Places | 02 Oct | No |
SN113 | Jazz | Acoustic Evening | 03 Nov | No |
SN124 | Classical | Mozart Evening | 04 Dec | Yes |
SN021 | Classical | Bach Favourites | 01 Feb | Yes |
SN032 | Jazz | 30 Years of Jazz | 02 Mar | Yes |
SN043 | Comedy | Street Night | 03 Apr | No |
SN054 | Comedy | Hoot | 04 May | No |
Show the output that would be given by this structured query language (SQL) statement:
SELECT Date, Title
FROM PERFORMANCE
WHERE NOT SoldOut AND Type = "Jazz";