Count the number of customers that have an email containing "gmail.com".
SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"
count the number of customers = COUNT(*); email containing 'gmail.com' refers to Email LIKE '%gmail.com%';