How is the result column going to be called?

COUNT(*)customerregulars

Make sure to pick COUNT(*).