### 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/main/java/org/elasticsearch/xpack/esql/analysis/Verifier.java
if (p instanceof Project == false || u instanceof UnsupportedAttribute == false) {
                            failures.add(fail(ae, u.unresolvedMessage()));
                        }
                    }
                    if (ae.typeResolved().unresolved()) {
                        failures.add(fail(ae, ae.typeResolved().message()));
                    }
                });
            });
        });
        
        if (failures.isEmpty() == false) {
            return failures;
        }
        
        plan.forEachDown(p -> {
            
            if (p.childrenResolved() == false) {
                return;
            }
            checkFilterConditionType(p, failures);
            checkAggregate(p, failures);
            checkRegexExtractOnlyOnStrings(p, failures);
            checkRow(p, failures);
            checkEvalFields(p, failures);
            checkOperationsOnUnsignedLong(p, failures);
            checkBinaryComparison(p, failures);
        });