### Description

`stats x = count`  throws error `unknown column [count]` which is confusing since stats does not allow aliasing for existing columns but only points to aggregate functions.
Hence why the message should be `incorrect function declaration count, you forgot to add the parantheisis`. 
Same approach when dealing with a typo: `stats x = cont(*)` - `Unkown aggregate function cont - did you mean count()?`

x-pack/plugin/esql/src/test/java/org/elasticsearch/xpack/esql/analysis/VerifierTests.java
rightType = type;
                } else {
                    left = "n";
                    leftType = type;
                    right = "ul";
                    rightType = "unsigned_long";
                }
                var op = left + " " + operation + " " + right;
                assertThat(
                    error("row n = to_" + type + "(1), ul = to_ul(1) | eval " + op),
                    containsString(
                        "first argument of ["
                            + op
                            + "] is ["
                            + leftType
                            + "] and second is ["
                            + rightType
                            + "]."
                            + " [unsigned_long] can only be operated on together with another [unsigned_long]"
                    )
                );
            }
        }
    }
    public void testUnsignedLongNegation() {
        assertEquals(
            "1:29: negation unsupported for arguments of type [unsigned_long] in expression [-x]",
            error("row x = to_ul(1) | eval y = -x")
        );
    }