Table schema:
CREATE TABLE CUSTOMER (Email VARCHAR)

Question: How many customers have email that contains "gmail.com"?
SQL: SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"