SELECT
    (SELECT
     Count(t1.x)
     FROM Referrals t1
     WHERE t1.[Today's Date]>#2003/07/29# AND t1.y=t2.y) AS numberOfx,
    t2.y
FROM Referrals AS t2
GROUP BY t2.y