## 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/breakdown_props.py
if not use_all_funnel_entities:
        props_to_filter = filter.property_groups.combine_property_group(
            PropertyOperatorType.AND, entity.property_groups
        )
    else:
        props_to_filter = filter.property_groups
    person_join_clauses = ""
    person_join_params: Dict = {}
    groups_join_clause = ""
    groups_join_params: Dict = {}
    sessions_join_clause = ""
    sessions_join_params: Dict = {}
    null_person_filter = f"AND e.person_id != toUUIDOrZero('')" if team.actor_on_events_querying_enabled else ""
    if person_properties_mode == PersonPropertiesMode.DIRECT_ON_EVENTS:
        outer_properties: Optional[PropertyGroup] = props_to_filter
        person_id_joined_alias = "e.person_id"
        if not groups_on_events_querying_enabled():
            groups_join_clause, groups_join_params = GroupsJoinQuery(filter, team.pk, column_optimizer).get_join_query()
    else:
        outer_properties = column_optimizer.property_optimizer.parse_property_groups(props_to_filter).outer
        person_id_joined_alias = "pdi.person_id"
        person_query = PersonQuery(
            filter, team.pk, column_optimizer=column_optimizer, entity=entity if not use_all_funnel_entities else None
        )
        if person_query.is_used:
            person_subquery, person_join_params = person_query.get_query()
            person_join_clauses = f"""
                INNER JOIN ({get_team_distinct_ids_query(team.pk)}) AS pdi ON e.distinct_id = pdi.distinct_id
                INNER JOIN ({person_subquery}) person ON pdi.person_id = person.id
            """