Nested count fails #8450
Description
Describe the bug
Queries with a nested count (select count(*) from (select count(*) from (select 1));)
fail with
Optimizer rule 'optimize_projections' failed
caused by
Error during planning: Aggregate requires at least one grouping or aggregate expression
To Reproduce
No response
Expected behavior
Should return the number of rows (1)
Additional context
No response