Count Over returns Row_Number based on Order By
If I run this query I will get the ROW_NUMBER() instead of the COUNT()


OVER Clause (Transact-SQL)


  If ORDER BY is not specified entire partition is used for a window frame. This applies only to functions that do not require ORDER BY clause. If ROWS/RANGE is not specified but ORDER BY is specified, RANGE UNBOUNDED PRECEDING AND CURRENT ROW is used as default for window frame. This applies only to functions that have can accept optional ROWS/RANGE specification.