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. /Two conditions with AND and OR
Computer ScienceEasyHigh School (9–10)Computer Science › Databases and SQL

Two conditions with AND and OR

The same Sales table. You will join two conditions with AND or OR.

Your tasks.

  1. script_1: the SaleID of every apple sale at the North market.
  2. script_2: the SaleID of every sale that is of pears or is at the South market.
  3. script_3: the number of sales from 333 to 555 kilograms, including both ends.

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 AND to OR in script_1. Predict how many sales are output now.

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
← Counting and adding up salesThe three gates as functions →
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 labs on this topic

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