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 school garden club records each plot in a table Plots: the water it needs each day in litres, its…
HardComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalIGCSE

A school garden club records each plot in a table Plots: the water it needs each day in litres, its…

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 school garden club records each plot in a table Plots: the water it needs each day in litres, its hours of sun and whether it is shaded by a tree.

table
Plot  WaterL  SunHours  Shaded
A     4       6         FALSE
B     9       3         TRUE
C     12      2         TRUE
D     2       8         FALSE
E     7       5         TRUE
F     3       7         FALSE
  1. What does this script output?
sql
SELECT SUM(WaterL) FROM Plots WHERE Shaded = TRUE AND SunHours < 4;
  1. What does this script output?
sql
SELECT COUNT(*) FROM Plots WHERE WaterL > 3 OR Shaded = TRUE;

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. Part (a), shaded plots. B, C and E.

Step 2. Of those, fewer than 444 hours of sun. B (333) and C (222). E has 555 hours, so it fails.

Step 3. Add the water. 9+12=219 + 12 = 219+12=21, so the output is 212121.

Step 4. Part (b). More than 333 litres: A, B, C and E. Shaded: B, C and E, which are already in the list. So 444 plots pass.

Watch out. Adding the two groups, 4+3=74 + 3 = 74+3=7, counts B, C and E twice. With OR each record counts once.

Answer: (a) 212121. (b) 444.

Log in to save this for later
← All Problems
← A school weather station stores one record a day in a table Weather: the rainfall in millimetres…A gym stores its members in a table Gym… →
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 weather station stores one record a day in a table Weather: the rainfall in millimetres…
Medium
  • A camera club lends out equipment and stores each loan in a table Loans…Medium
  • All problems on this topic →