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 shop keeps this table, Products. Write down the output of this script…
MediumComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalIGCSE

A shop keeps this table, Products. Write down the output of this 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 shop keeps this table, Products.

table
ProductID  Name       Category  Price  Stock
G01        Trowel     Garden    6.5    14
K02        Teapot     Kitchen   12.5   3
G03        Hose       Garden    19.0   0
K04        Whisk      Kitchen   4.0    22
G05        Seed tray  Garden    3.5    40
K06        Ladle      Kitchen   5.0    9

Write down the output of this script.

sql
SELECT Name, Stock
FROM Products
WHERE Category = 'Kitchen'
ORDER BY Stock ASC;

How many rows does it output, and what is the stock of the last row?

Check your answer

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

Need a reminder? The key ideaShowHide

ORDER BY field ASC sorts the output smallest first (A to Z, earliest date first); DESC sorts largest first. The clauses come in the order SELECT, FROM, WHERE, ORDER BY. Keep the records that pass, sort them, then show the selected fields.

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. Keep the kitchen products. Teapot (333), Whisk (222222) and Ladle (999).

Step 2. Sort them by stock, smallest first. 333, 999, 222222.

Step 3. The output.

sql
SELECT Name, Stock
FROM Products
WHERE Category = 'Kitchen'
ORDER BY Stock ASC;

The output:

table
Name    Stock
Teapot  3
Ladle   9
Whisk   22

Answer: 333 rows; the last row is Whisk with 222222 in stock.

Log in to save this for later
← All Problems
← A fair lists its rides and the length of each ride in minutes in a table Rides…A community hall stores its events in a table Events… →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. ORDER BY: sorting the outputSQL Queries: SELECT, WHERE and ORDER BY

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 →