The following image shows a language parsing error related to the filter() function. The error appears when there is no accompanying OVER window function definition. The SQL executes fine,
An OVER window function is not required to used FILTER(). I could get the same result using a subquery, but FILTER() is so much more simplified.