<h3 id="heading-count">Count</h3>
This counts the number of frequency
<pre><code>SELECT COUNT(*) FROM Country
#counts the number of rows in the Country Table
</code></pre><h3 id="heading-count-with-distinct">Count with Distinct</h3>
<pre><code>SELECT COUNT(DISTINCT COLUMN_NAME)

SELECT COUNT(DISTINCT States) as States
FROM Country
#counts the unique states in Country table
</code></pre><h3 id="heading-count-aggregation">Count Aggregation</h3>
<ul>
<li>GROUP BY can be used with COUNT() in the same way as the other aggregation functions such as AVG(), MIN(), MAX().
</li>
<li>Use the ORDER BY command to sort the values
<pre><code> -DESC will return the largest values to the smallest
 -ASC will return the smallest values to the largest
</code></pre></li>
</ul>

### Count
This counts the number of frequency

```
SELECT COUNT(*) FROM Country
#counts the number of rows in the Country Table
``` 
 ### Count with Distinct

```
SELECT COUNT(DISTINCT COLUMN_NAME)

SELECT COUNT(DISTINCT States) as States
FROM Country
#counts the unique states in Country table
``` 

### Count Aggregation

- GROUP BY can be used with COUNT() in the same way as the other aggregation functions such as AVG(), MIN(), MAX().

- Use the ORDER BY command to sort the values
        -DESC will return the largest values to the smallest
        -ASC will return the smallest values to the largest








Counting and Total in Sql

Count

Count with Distinct

Count Aggregation