The Aggregate count function doesn't work with the over clause in MonetDB. I am a new user on MonetDB, and have trouble using queries running on other databases like Postgres on MonetDB.
When using the Count function with Over clause I get the following error:
sql>select count(id) over() from sample_table ;
SELECT: function 'count' not found