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. /Counting and adding up sales
Computer ScienceEasyHigh School (9–10)Computer Science › Databases and SQL

Counting and adding up sales

A fruit stall keeps a table Sales with the fields SaleID, Fruit, Kg and Market. You will write three scripts that each output one number.

Your tasks.

  1. script_1: the number of sales in the table.
  2. script_2: the total number of kilograms sold.
  3. script_3: the total number of kilograms of apples sold.

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, write a fourth script: the number of sales at the North market. Predict its output first.

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
← Sorting with ORDER BYTwo conditions with AND and OR →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. Counting and adding with COUNT and SUMSQL: SUM, COUNT, AND, OR and Reading Query Output

More labs on this topic

  1. Two conditions with AND and OREasy
  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 →