In recent versions of MySQL (8.0+), what's the correct syntax to declare a CTE (Common Table Expression)?
WITH cte as (SELECT id FROM users), SELECT ...
WITH (SELECT id FROM users) as cte, SELECT ...
WITH (SELECT id FROM users) as cte SELECT ...
WITH cte as (SELECT id FROM users) SELECT ...