Database: chinook_1
Question: Count the number of customers that have an email containing "gmail.com".
SQL:
SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"