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 camera club lends out equipment and stores each loan in a table Loans…
MediumComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalIGCSE

A camera club lends out equipment and stores each loan in a table Loans…

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 camera club lends out equipment and stores each loan in a table Loans. Days is the length of the loan.

table
LoanID  Item    Days
N1      Camera  3
N2      Tripod  7
N3      Camera  10
N4      Lamp    2
N5      Tripod  1
  1. How many records pass WHERE Item = 'Tripod' OR Days >= 7?
  1. What does SELECT SUM(Days) FROM Loans WHERE Item = 'Tripod' OR Days >= 7; output?

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. Tripod loans. N2 and N5.

Step 2. Loans of 777 days or more. N2 (777) and N3 (101010).

Step 3. Together. N2, N3 and N5: 333 records. N2 meets both parts, but it is one record.

Step 4. The sum. 7+10+1=187 + 10 + 1 = 187+10+1=18 days.

Answer: (a) 333 records. (b) 181818.

Log in to save this for later
← All Problems
← A decorator lists her tins of paint in a table Paints…A school weather station stores one record a day in a table Weather: the rainfall in millimetres… →
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 →