IGCSE Algorithms and Pseudocode Practice Exam 2026 – The All-in-One Guide to Mastering Foundations for Grade 8!

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards

From $12.50Unlock all

Session length

1 / 20

Which SQL function would you use to count rows that satisfy a condition?

SUM

AVG

MAX

COUNT

Counting how many rows meet a condition is done with the COUNT function in SQL. You’d typically write a query like SELECT COUNT(*) FROM table WHERE condition, and COUNT tallies every row that satisfies that condition. COUNT(*) counts all matching rows, while COUNT(column) counts non-null values in a specific column, which is a slightly different way to measure data.

The other options perform different tasks: SUM adds up numeric values across rows, AVG computes the average of numeric values, and MAX finds the largest value. They don’t count rows that meet a condition, which is why COUNT is the appropriate choice for this requirement.