The Price field in a database table named Product stores the cost of each inventory item in pounds (£).
A database administrator wants to write a query to increase the Price by 5 for all products that have a ReorderLevel of less than 15.
The drafted query is shown in Figure 1.
UPDATE Product
SET Price = Price + 4
WHERE ReorderLevel >= 15
The query contains two errors. Refine the query in Figure 1 to correct the errors.
25 exam-style questions on AQA GCSE Computer Science Structured query language (SQL). Each one has a worked solution and a mark scheme showing where the marks go.