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 town library stores its readers in a table Readers…
MediumComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalConceptualIGCSE

A town library stores its readers in a table Readers…

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 town library stores its readers in a table Readers. Loans is the number of books each reader borrowed this year.

table
ReaderID  Name  Type   Loans
R1        Ava   Adult  5
R2        Ben   Child  12
R3        Cleo  Adult  15
R4        Dev   Child  4
R5        Eli   Adult  8

The librarian wants the total number of loans made by the readers who are children or who borrowed more than 101010 books. Complete the script and give its output.

sql
SELECT ________(Loans)
FROM Readers
WHERE Type = 'Child' ________ Loans > 10;

Check your answer

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

Need a reminder? The key ideaShowHide

To give the output of a script, work in this order: the table (FROM), the records that pass (WHERE), COUNT or SUM if there is one, the sort (ORDER BY), and last the selected fields (SELECT). To correct a script, check the clause order, the commas, the names, the quotes and each condition.

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 first gap. A total of loans: SUM.

Step 2. The second gap. A child or a reader with more than 101010 loans: OR.

Step 3. The records that pass. Ben (Child, 121212), Dev (Child, 444) and Cleo (Adult, 151515).

Step 4. The sum. 12+4+15=3112 + 4 + 15 = 3112+4+15=31.

Answer: SELECT SUM(Loans) FROM Readers WHERE Type = 'Child' OR Loans > 10; outputs 313131.

Log in to save this for later
← All Problems
← A gym stores its members in a table Gym…A restaurant stores its staff in a table Staff… →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. Reading, completing and correcting SQL scriptsSQL: 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 gym stores its members in a table Gym…Easy
  3. A school garden club records each plot in a table Plots: the water it needs each day in litres, its…Hard
  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 →