Hi,,, i did this...

SELECT COUNT(CustomerGender) AS MaleCount
FROM customers.CustomerGender
WHERE customers.CustomerGender = 'Male';

and this works, but is only of course a tiny part of the eventual whole query