## Bug description

When calculating Trends results with an aggregated (e.g. single output, like big number) display type, WAU/MAU don't work. This is because we have an `ACTIVE_USERS_SQL` query for time series display types, but we don't have a version of this for aggregated display types. (See ZEN-1043.)

## How to reproduce

1. Create an insight with a single WAU or MAU series.
2. Switch display type to "Number".
3. Open the "Debug ClickHouse queries" modal from the command palette.
4. See `COUNT(*)` instead of `COUNT(DISTINCT person_id)`.

#### *Thank you* for your bug report – we love squashing them!

posthog/queries/person_query.py
if not isinstance(self._filter, Filter):
            return "", {}
        if self._filter.distinct_id:
            distinct_id_clause = f"""
            AND id IN (
                SELECT person_id FROM ({get_team_distinct_ids_query(self._team_id)}) where distinct_id = %(distinct_id_filter)s
            )
            """
            return distinct_id_clause, {"distinct_id_filter": self._filter.distinct_id}
        return "", {}
    def _get_email_clause(self) -> Tuple[str, Dict]:
        if not isinstance(self._filter, Filter):
            return "", {}
        if self._filter.email:
            return prop_filter_json_extract(
                Property(key="email", value=self._filter.email, type="person"), 0, prepend="_email"
            )
        return "", {}