In SQL, when you want to count how many records match a certain condition (like how many students are in a class), you use the ____ function. It returns the number of rows that meet your condition. If you want to add up all the values in a numeric field — such as finding the total age of students or the total number of books sold — you use the ____ function. This is helpful when you're working with numbers and need a total amount. The syntax for both of these functions includes the keyword ____, which tells the database which table to look in. You can also combine these functions with the ____ clause to limit your total or count only to specific records, such as students from class '6B' or with age greater than 12. For example: ____ ____ ____ ____ ____ ____ = ____; Another example using total: ____ ____ ____ ____ ____ ____ = ____;

SQL SUM & COUNT basics

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?