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. Python Labs
  2. /Choosing records with WHERE
Computer ScienceEasyHigh School (9–10)Computer Science › Databases and SQL

Choosing records with WHERE

A vet keeps a table Pets with the fields PetID, Name, Animal, Age and Vaccinated. You will write three scripts that choose records with WHERE.

Your tasks.

  1. script_1: the Name of every cat.
  2. script_2: the Name and the Age of every pet older than 555 years.
  3. script_3: the PetID of every pet that is not vaccinated.

Run it first, just as it is. The checker at the end prints FAIL for each task. Then do the tasks one at a time, and run the program again after each one. A Hint appears under every check that still fails.

When every line says PASS, change script_2 to use >= with 777. Predict which pets are output before you run it.

StemPy LabContributed by StemPy Lab
python
Loading Python runtime…

A worked solution

Have you tried it?

Do the tasks in the editor first, and run the checker after each one. Its hints help when a check fails. When you are ready, compare your code with this solution.

Log in to save
← All Labs
← Validation checks before a record is storedSorting with ORDER BY →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. WHERE: choosing the recordsSQL Queries: SELECT, WHERE and ORDER BY

More labs on this topic

  1. Two conditions with AND and OREasy
  2. Counting and adding up salesEasy
  3. Sorting with ORDER BYEasy
  4. Validation checks before a record is storedEasy
Build a table with a primary keyEasy
All labs on this topic →