Hello my name is Andrew,
I believe that I've found a bug within postgres where an aggregate function is not accepted when an order by clause is specified, here is a short example:
postgres=# select version();
version
-----------------------------------------------------------------------------------------------------------------------------
PostgreSQL 14.2 (Debian 14.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
(1 row)
postgres=# create table test_table(i int);
CREATE TABLE
postgres=# insert into test_table values (1);
INSERT 0 1
postgres=# select COUNT(i) from test_table;
count
-------
1
(1 row)
postgres=# select COUNT(i) from test_table order by i;
ERROR: column "test_table.i" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select COUNT(i) from test_table order by i;
^
