Why the query does not execute and rewrite so that it can be executed 

WITH users_2019 (id, name) AS (SELECT *

FROM users

WHERE join_date BETWEEN '2019-01-01' AND '2019-12-31')

SELECT id,

name, count(licenses.access_code) AS numFROM users_2019

LEFT JOIN licenses ON licenses.user_id = id

GROUP BY name ORDER BY num DESC;