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. /Sorting with ORDER BY
Computer ScienceEasyHigh School (9–10)Computer Science › Databases and SQL

Sorting with ORDER BY

The same Pets table. You will write three scripts that sort their output with ORDER BY.

Your tasks.

  1. script_1: the Name of every pet, oldest first.
  2. script_2: the Name of every pet, in alphabetical order (A to Z).
  3. script_3: the Name and the Age of every dog, youngest first.

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, sort the dogs by Name DESC instead. Which dog is first 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
← Choosing records with WHERECounting and adding up sales →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. ORDER BY: sorting the outputSQL 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. Choosing records with WHEREEasy
  4. Validation checks before a record is storedEasy
Build a table with a primary keyEasy
All labs on this topic →