🪲 COUNT(*) doesn't work on aggregates without GROUP BY

[gva-jjoyce]

SQL statement
Please submit the SQL statement, or a representative example using the sample datasets.

SELECT COUNT(*), COUNT_DISTINCT(id)
  FROM $planets

Column '*' not found

but this query does work:

SELECT COUNT(*), COUNT_DISTINCT(id)
  FROM $planets
 GROUP BY TRUE