COUNT()

COUNT() is an aggregate function that returns how many rows match a query. COUNT(*) counts all rows, while COUNT(column) counts only rows where that column…