HelpContactFor teachers and institutes
>_StemPy Lab
Mock TestsClasses

>_StemPy Lab

Learn. Solve. Code the solutions. Test yourself.

Live examsFree mock exams, timed and rankedEveryone starts together, and your score and rank come the moment it ends.See the exams →

Learn

  • Physics
  • Chemistry
  • Mathematics
  • Biology
  • Python Programming
  • Statistics & Data Science
  • Computer Science
  • Classes
  • Groups

Practice

  • Problems
  • Quizzes
  • Mock Tests
  • Prepare for an Exam
  • Question Sets
  • Exams
  • Certificates
  • Python Labs
  • AI Practice Generator
  • Student-Created Tests

Community

  • Discussions
  • Resources
  • Notes
  • Glossary
  • Blog

Account

  • Log in
© 2026 senLearn. All rights reserved.HelpFor SchoolsAboutContactPrivacy PolicyTerms of UseRefund Policy
  1. Problems
  2. /A café keeps its orders in a table Orders. Cost is in dollars. Give the output of each script.
EasyComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalIGCSE

A café keeps its orders in a table Orders. Cost is in dollars. Give the output of each script.

StemPy LabContributed by StemPy Lab

Try it on paper first. A hint, the key idea and the worked solution are here when you need them.

A café keeps its orders in a table Orders. Cost is in dollars.

table
OrderID  Item   Size   Cups  Cost
C1       Tea    Small  2     6
C2       Soup   Large  1     7
C3       Tea    Large  3     12
C4       Juice  Small  4     10
C5       Soup   Small  2     8
C6       Tea    Small  1     3

Give the output of each script.

sql
SELECT COUNT(*) FROM Orders WHERE Item = 'Tea';
SELECT SUM(Cups) FROM Orders WHERE Item = 'Tea';

Check your answer

Work it out on paper, then type your number. The answer itself stays hidden.

Need a reminder? The key ideaShowHide

COUNT(*) counts the records that pass the WHERE condition. SUM(Field) adds up a numeric field of the records that pass. Each gives one value. "How many orders?" is a count; "how many cups?" is a sum of the Cups field.

The worked solution

Have you tried it?

Work it out on paper first. It is fine to get stuck or make a mistake: that is how we learn. When you are ready, go through the solution one step at a time, and check each step against your own.

Step 1. The tea orders. C1, C3 and C6.

Step 2. COUNT. There are 333 of them, so the first script outputs 333.

Step 3. SUM. Their cups are 222, 333 and 111, so the second script outputs 2+3+1=62 + 3 + 1 = 62+3+1=6.

Answer: 333 and 666.

Log in to save this for later
← All Problems
← A community hall stores its events in a table Events…A school kitchen records each lunch order in a table Lunches… →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. Counting and adding with COUNT and SUMSQL: SUM, COUNT, AND, OR and Reading Query Output

More on this topic

  1. A restaurant stores its staff in a table Staff…Hard
  2. A town library stores its readers in a table Readers…Medium
  3. A gym stores its members in a table Gym…Easy
  4. A school garden club records each plot in a table Plots: the water it needs each day in litres, its…
Hard
  • A school weather station stores one record a day in a table Weather: the rainfall in millimetres…Medium
  • All problems on this topic →