CREATE TABLE CUSTOMER (Email VARCHAR)

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 "%gmail.com%"