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 decorator lists her tins of paint in a table Paints…
EasyComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalIGCSE

A decorator lists her tins of paint in a table Paints…

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 decorator lists her tins of paint in a table Paints. Litres is the amount in each tin.

table
Tin  Colour  Finish  Litres
P1   White   Gloss   5
P2   Grey    Matt    2
P3   White   Matt    1
P4   White   Gloss   3
P5   Grey    Gloss   5

Give the output of this script, and say how many records it outputs.

sql
SELECT Tin
FROM Paints
WHERE Colour = 'White' AND Finish = 'Gloss';

Check your answer

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

Need a reminder? The key ideaShowHide

With AND a record passes only if both conditions are true; with OR it passes if at least one is true. A range is Field >= low AND Field <= high; outside a range is Field < low OR Field > high. Each part needs its own field name.

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. Test each record. P1 is white and gloss: passes. P3 is white but matt: fails. P4 is white and gloss: passes. P5 is gloss but grey: fails.

Step 2. The output.

sql
SELECT Tin
FROM Paints
WHERE Colour = 'White' AND Finish = 'Gloss';

The output:

table
Tin
P1
P4

Answer: P1 and P4, 222 records.

Log in to save this for later
← All Problems
← A bus company stores each trip of one morning in a table Fares…A camera club lends out equipment and stores each loan in a table Loans… →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. Joining conditions with AND and ORSQL: 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 →