## 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/test/test_trends.py
properties={"$some_prop": "some_val"},
                uuid=test_person_ids[-1],
            )
            flush_persons_and_events()
            data = {"date_from": "-7d", "events": [{"id": "sign up", "math": "dau"}], "limit": 5}
            with override_instance_config("PERSON_ON_EVENTS_ENABLED", True):
                from posthog.models.team import util
                util.can_enable_person_on_events = True
                response = Trends().run(Filter(data=data), self.team)
                self.assertEqual(response[0]["data"], [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 10.0])
                url = response[0]["persons_urls"][7]["url"]
                people_response = self.client.get(f"/{url}").json()
                
                self.assertIsNotNone(people_response["next"])
                self.assertEqual(people_response["missing_persons"], 5)
                next_url = people_response["next"]
                second_people_response = self.client.get(f"{next_url}").json()
                self.assertIsNotNone(second_people_response["next"])
                self.assertEqual(second_people_response["missing_persons"], 4)
                first_load_ids = sorted(str(person["id"]) for person in people_response["results"][0]["people"])
                second_load_ids = sorted(str(person["id"]) for person in second_people_response["results"][0]["people"])
                self.assertEqual(len(first_load_ids + second_load_ids), 1)
                self.assertEqual(first_load_ids + second_load_ids, [str(person.uuid)])
                third_people_response = self.client.get(f"/{second_people_response['next']}").json()
                self.assertIsNone(third_people_response["next"])
                self.assertFalse(third_people_response["missing_persons"])
                third_load_ids = sorted(str(person["id"]) for person in third_people_response["results"][0]["people"])
                self.assertEqual(third_load_ids, [])
    
    def test_no_props(self):