SQL|Comparing COUNT(*)-COUNT(1)-COUNT('a')-COUNT(col_nm)-COUNT(DISTINCT col_nm)|Common SQL question?

In this video we compare the different usage of COUNT in SQL and see the results obtained by implementing the variations.
The COUNT() function returns the number of rows that matches a specified criterion (specified in the WHERE clause if any).
The following variations are compared -
COUNT(*)
COUNT(1)
COUNT('a')
COUNT(col_nm)
COUNT( DISTINCT col_nm)
"Thanks for watching. If you liked this video, make sure to subscribe for more!”
#dataprojecthub
#data_project_hub