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