## 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
elif column_optimizer.is_using_cohort_propertes:
            person_join_clauses = f"""
                INNER JOIN ({get_team_distinct_ids_query(team.pk)}) AS pdi ON e.distinct_id = pdi.distinct_id
            """
        groups_join_clause, groups_join_params = GroupsJoinQuery(filter, team.pk, column_optimizer).get_join_query()
    session_query = SessionQuery(filter=filter, team=team)
    if session_query.is_used:
        session_query_clause, sessions_join_params = session_query.get_query()
        sessions_join_clause = f"""
                INNER JOIN ({session_query_clause}) AS {SessionQuery.SESSION_TABLE_ALIAS} ON {SessionQuery.SESSION_TABLE_ALIAS}.$session_id = e.$session_id
        """
    prop_filters, prop_filter_params = parse_prop_grouped_clauses(
        team_id=team.pk,
        property_group=outer_properties,
        table_name="e",
        prepend="e_brkdwn",
        person_properties_mode=person_properties_mode,
        allow_denormalized_props=True,
        person_id_joined_alias=person_id_joined_alias,
    )
    if use_all_funnel_entities:
        from posthog.queries.funnels.funnel_event_query import FunnelEventQuery
        entity_filter, entity_params = FunnelEventQuery(
            filter, team, using_person_on_events=team.actor_on_events_querying_enabled
        )._get_entity_query()
        entity_format_params = {"entity_query": entity_filter}
    else:
        entity_params, entity_format_params = get_entity_filtering_params(
            entity=entity,
            team_id=team.pk,