What is the alternative for Redshift to the filter (where...) that is possible in Postgres?
I get the following error and cannot figure out whether this is not possible in Redshift or I have a syntax error:
The database reported a syntax error: Amazon Invalid operation: syntax error at or near "(" Position: 1521;

```
select count(distinct "agent.id")  as "agent_cnt"
, count(distinct "agent.id") filter (where "agent.status" = 'active' and ("agent.date" between '2020-01-01' and current_date)) as "active_agent_cnt"
from "agent" 

```