hi, hi don't see the advantage of CTE to temp Tables like in the example below. Is there any advantage?

WITH

CountEmployees(dept_id, n) AS

( SELECT dept_id,...