Skip to content

Course home

Structured query language (SQL)

Structured query language (SQL)

EasyMediumHard
1234567891011
Question 5

A transport logistics database contains a table named Consignment.

The database has fields ShippingFee (storing the delivery charge in pounds) and TransitDays (storing the delivery duration in days).

The logistics manager wants to write an SQL query to apply a discount of 15 to the ShippingFee for all consignments that have a TransitDays value of more than 10.

The drafted query is shown below:

UPDATE Consignment
SET ShippingFee = ShippingFee + 15
WHERE TransitDays <= 10

The query contains two errors. Refine this SQL query to correct the errors.

[2]
Markscheme

Structured query language (SQL) Questions

  1. GCSE
  2. /Computer Science
  3. /Structured query language (SQL)

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.

Question bank