Computer Science · May / June 2024 · Paper 21 · Question 9
0478
As printed in the paper
The question as text
A database table called SoftDrinks stores details of the soft drinks sold by a small shop. Field Example data Name Cola Supplier Cambridge Beverages Container Can SizeCl 330 NumberInStock 30 ReorderLevel 15 Reordered Yes
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
9(a)[1]
One mark for an appropriate reason if no has been stated, for example:
None of the fields are likely to contain unique data.
9(b)[5]
One mark for each correct answer
SUM
NumberInStock
SoftDrinks
Container
'Can'
Correct code:
SELECT SUM (NumberInStock)
FROM SoftDrinks
WHERE Container = 'Can';
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.