What is the id of the reviewer whose name has substring “Mike”?
CREATE TABLE Reviewer (rID VARCHAR, name VARCHAR)
SELECT rID FROM Reviewer WHERE name LIKE "%Mike%"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Reviewer (rID VARCHAR, name VARCHAR) Question: What is the id of the reviewer whose name has substring “Mike”? [/INST] SELECT rID FROM Reviewer WHERE name LIKE "%Mike%" </s>