Computer Science · May / June 2021 · Paper 22 · Question 6

A database table, PLANT, is used to keep a record of plants sold by a nursery. The table has these fields: • NAME – name of plant • FLOWER – whether the plant flowers (True) or not (False) • POSITION – shade, partial shade or sun • SIZE – small, medium or large • PRICE – price in $ • NUMBERSOLD – how many sold A query-by-example grid has been completed to display only the price, name and number sold of small plants that do not flower. Field: NAME PRICE NUMBERSOLD SIZE FLOWER POSITION Table: PLANT Sort: Show: 3 3 3 riteria: = "shade" or: Identify the errors in the query-by-example grid. Rewrite the corrected query-by-example grid. Field: Table: Sort: Show: riteria: or: [5]

Read automatically from the paper; the printed page above is exact.