Database: e_commerce
Question: What are the email addresses, cities, and counties listed for all cusomters who are from the gender that orders less often?
SQL:
SELECT email_address ,  town_city ,  county FROM Customers WHERE gender_code  =  ( SELECT gender_code FROM Customers GROUP BY gender_code ORDER BY count(*) ASC LIMIT 1 )