Which Event has a Surface of semifinal, and a Winner of hard (i)?
CREATE TABLE table_name_23 (MAX VARCHAR, surface VARCHAR, winner VARCHAR)
SELECT NOT MAX <> 0 AS event FROM table_name_23 WHERE surface = "semifinal" AND winner = "hard (i)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (MAX VARCHAR, surface VARCHAR, winner VARCHAR) Question: Which Event has a Surface of semifinal, and a Winner of hard (i)? [/INST] SELECT NOT MAX <> 0 AS event FROM table_name_23 WHERE surface = "semifinal" AND winner = "hard (i)" </s>