## Bug description

*Please describe.*  
- some datapoints show 0 but people will appear in modal

*If this affects the front-end, screenshots would be of great help.*  

## Expected behavior
- amount of people and datapoint should be the same


## How to reproduce

1. demo data clickhouse instance
2. go to retention trends for a day with some people


## Environment

- [ ] PostHog Cloud
- [ ] self-hosted PostHog, version/commit: _please provide_

## Additional context



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

ee/clickhouse/queries/clickhouse_retention.py
def _execute_sql(self, filter: RetentionFilter, team: Team,) -> Dict[Tuple[int, int], Dict[str, Any]]:
        period = filter.period
        prop_filters, prop_filter_params = parse_prop_clauses(filter.properties, team.pk)
        target_entity = filter.target_entity
        returning_entity = filter.returning_entity
        is_first_time_retention = filter.retention_type == RETENTION_FIRST_TIME
        date_from = filter.date_from
        date_to = filter.date_to
        target_query = ""
        target_params: Dict = {}
        trunc_func = get_trunc_func_ch(period)
        target_query, target_params = self._get_condition(target_entity, table="e")
        returning_query, returning_params = self._get_condition(returning_entity, table="e", prepend="returning")
        target_query_formatted = "AND {target_query}".format(target_query=target_query)
        returning_query_formatted = "AND {returning_query}".format(returning_query=returning_query)
        reference_event_sql = (REFERENCE_EVENT_UNIQUE_SQL if is_first_time_retention else REFERENCE_EVENT_SQL).format(
            target_query=target_query_formatted, filters=prop_filters, trunc_func=trunc_func,
        )
        target_condition, _ = self._get_condition(target_entity, table="reference_event")
        if is_first_time_retention:
            target_condition = target_condition.replace("reference_event.uuid", "reference_event.min_uuid")
            target_condition = target_condition.replace("reference_event.event", "reference_event.min_event")
        returning_condition, _ = self._get_condition(returning_entity, table="event", prepend="returning")