Code:
Select CF1, Count(qryCountFails.CF1) As CountF1 FROM
(SELECT ServicingInputTable.[Correct Greeting]=0 AS
CF1 FROM ServicingInputTable) As qryCountFails
GROUP BY CF1;
the above fails with the same error. This is in the access query builder SQL view.

Syntax error in FROM clause, and highlights the select in bold