How many customers have email that contains "gmail.com"?
SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"
email that contains 'gmail.com' refers to Email LIKE '%gmail.com%'; number of customers = COUNT(*);