How many customers have email that contains "gmail.com"?
CREATE TABLE CUSTOMER (Email VARCHAR)
SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE CUSTOMER (Email VARCHAR) Question: How many customers have email that contains "gmail.com"? [/INST] SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%" </s>