For the light heavyweight –81 kg event that did not advance to semifinal, who was the athlete?
CREATE TABLE table_name_26 (athlete VARCHAR, semifinal VARCHAR, event VARCHAR)
SELECT athlete FROM table_name_26 WHERE semifinal = "did not advance" AND event = "light heavyweight –81 kg"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (athlete VARCHAR, semifinal VARCHAR, event VARCHAR) Question: For the light heavyweight –81 kg event that did not advance to semifinal, who was the athlete? [/INST] SELECT athlete FROM table_name_26 WHERE semifinal = "did not advance" AND event = "light heavyweight –81 kg" </s>