Hey,
An aggregate function that returns the number of rows, or the number of non-NULL rows. Count interval may be optionally specified.
Syntax:
COUNT([DISTINCT | ALL] expression) [OVER (analytic_clause)]
Depending on the argument, COUNT() considers rows that meet certain conditions.