SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"
How many customers have email that contains "gmail.com"?
SELECT COUNT ( * ) FROM CUSTOMER WHERE Email LIKE `` % gmail.com % ''
select count ( * ) from customer where email like value
How many customers have email that contains `` gmail.com '' ?