I'm trying to write a query that will give me the total counts on a column i

I'm trying to write a query that will give me the total counts on a column in the table. But Appian says you can't use a "*" ...asterisk. Below is my simple query and works outside of Appian. How do I get around this in Appian?

SELECT ROUTE_NAME, COUNT(*) AS "Routing List Total"
FROM CFUSER_DOCUMENT
WHERE SALARY > 10000 =
GROUP BY ROUTE_NAM

Thanks!

OriginalPostID-141077

OriginalPostID-141077