So going down the temp table route:

DROP TABLE IF EXISTS #tmptmp;

WITH e
AS (SELECT LastName,
           COUNT(*) norows,
 ...