Differentiate between COUNT ( ) and COURT (*) functions in MYSQL. Give suitable examples to support your answe

Question 33 of 40

Q. Differentiate between COUNT ( ) and COURT (*) functions in MYSQL. Give suitable examples to support your answer.

Punjab PsebCBSE Class XII Board 2023Subjective· 2mImportance★★★★★

83% · 33/40 Questions

🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

Concept understanding — SQL Aggregate Functions

Imagine you have a giant box of receipts from a month of sales at a small shop. You don't want to look at every single receipt one by one — you want a single, useful number that summarises the whole pile. How much total money came in? What was the average sale? How many customers bought something? That instinct — to collapse a pile of raw details into one meaningful number — is exactly what an SQL aggregate function does.

In a database, a table might hold thousands of rows of data: one row for every sale, every student, every product. An aggregate function takes all those rows in a column and boils them down to a single value. It doesn't change the data; it answers a question about the whole set. The most common ones are COUNT, SUM, AVG, MIN, and MAX. Each one has a clear, everyday meaning.

COUNT tells you how many rows there are — like counting how many students are in a class list. SUM adds up all the numbers in a column — like totalling the marks of every student in an exam. AVG gives the average of those numbers. MIN and MAX find the smallest and largest values — the lowest temperature recorded or the highest sale of the day.

Note

Aggregate functions work on a column of data, not across rows. You always write them as FUNCTION_NAME(column_name). For example, AVG(price) gives the average of all prices in that column.

The real power comes when you combine them with the GROUP BY clause. Without GROUP BY, an aggregate function summarises the entire table. With GROUP BY, you split the table into groups first, then apply the function to each group separately. Think of it like this: you don't just want the average sale for the whole year — you want the average sale per month. GROUP BY month creates twelve groups, and AVG(sale_amount) runs once for each group, giving you twelve averages.

This is why aggregate functions matter in business, economics, and any data-driven decision. A manager doesn't ask "what was every single transaction?" They ask "what was the total revenue last quarter?" or "which product category had the highest average rating?" Aggregate functions turn raw, overwhelming data into actionable summaries. …

Start your 14-day free trial to unlock the full solution →

Concept: Aggregate functions for counting rows in SQL queries.

There appears to be a typo in the question — MySQL has COUNT() but no COURT() function. The intended comparison is likely COUNT(column_name) versus COUNT(*).

Both count rows, but they handle NULL values differently:

COUNT(*) counts all rows in the result set, including those with NULL values in any column.
COUNT(column_name) counts only rows where the specified column is not NULL.

Example: Consider a table Students:

ID	Name	Email
1	Raj	raj@example.com
2	Priya	NULL
3	Amit	amit@example.com

Start your 14-day free trial to unlock the full solution →

COUNT() is an aggregate function that counts rows or non-NULL values in SQL; COURT(*) does not exist in MySQL — the question likely confuses COUNT(*) (count all rows) with COUNT(column) (count non-NULL values in a column).

There appears to be a typo in the question. MySQL has no function called COURT(*). The standard aggregate function is COUNT(), which comes in two main forms: COUNT(*) and COUNT(column_name). Understanding the difference between these two is essential for writing correct queries.

The Concept: What COUNT() Does

COUNT() is an aggregate function that returns the number of rows that match a criterion. The key distinction lies in what you ask it to count:

COUNT(*) counts every row in the result set, regardless of NULL values.
COUNT(column_name) counts only rows where that specific column is NOT NULL.

This difference becomes critical when your table contains NULL values, which represent missing or unknown data.

The Two Forms of COUNT()

1. `COUNT(*)` — Count All Rows

COUNT(*) counts every row returned by the query, including rows where some or all columns are NULL.

Example:

Suppose we have a table students:

id	name	email
1	Arjun	arjun@example.com
2	Priya	NULL
3	Rohan	rohan@example.com
4	Sneha	NULL

SELECT COUNT(*) FROM students;

Result: 4

All four rows are counted, even though two have NULL emails.

2. `COUNT(column_name)` — Count Non-NULL Values

COUNT(column_name) counts only the rows where the specified column contains a non-NULL value.

Example (same table):

SELECT COUNT(email) FROM students;

Result: 2

Only Arjun and Rohan have email addresses; Priya and Sneha's NULL emails are excluded.

Side-by-Side Comparison

Function	What It Counts	Treats NULL as
`COUNT(*)`	All rows in the result set	Counted
`COUNT(column_name)`	Rows where `column_name` IS NOT NULL	Ignored

Practical Use Cases

When to use COUNT(*): …

Start your 14-day free trial to unlock the full solution →

←Previous questionQ12 — Keshav has written the following query to find out the sum of bonus ea…→Next questionQ14 — State whether the following statement is True or False: The MOD() func…

Q.Differentiate between COUNT ( ) and COURT (*) functions in MYSQL. Give suitable examples to support your answer.

The Concept: What COUNT() Does

The Two Forms of COUNT()

1. COUNT(*) — Count All Rows

2. COUNT(column_name) — Count Non-NULL Values

Side-by-Side Comparison

Practical Use Cases

🎓Unlock everything free for 14 days

1. `COUNT(*)` — Count All Rows

2. `COUNT(column_name)` — Count Non-NULL Values

Unlock everything free for 14 days