Discuss the count function?
The COUNT function used returns the number of tuples or values fixed in a query.
The count function comprises two types of syntax: (1) COUNT (*) - returns the number of rows in the result query, (2) COUNT ([DISTINCT] ) - in this means, the NULL values are discarded and if employed then the duplicates are as well discarded in the count.