Which head's name has the substring 'Ha'? List the id and name.
CREATE TABLE head (head_id VARCHAR, name VARCHAR)
SELECT head_id, name FROM head WHERE name LIKE '%Ha%'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE head (head_id VARCHAR, name VARCHAR) Question: Which head's name has the substring 'Ha'? List the id and name. [/INST] SELECT head_id, name FROM head WHERE name LIKE '%Ha%' </s>