🪲 Can't use EXTRACT statement with a FOR clause

[joocer]

trafficstars

SELECT COUNT(*), EXTRACT(HOUR FROM dte)
FROM table
FOR date
GROUP BY EXTRACT(HOUR FROM dte)

The from in the EXTRACT statement confuses the temporal filters