Which actor played on Home and Away for 20 years?
CREATE TABLE table_name_21 (actor VARCHAR, duration VARCHAR, soap_opera VARCHAR)
SELECT actor FROM table_name_21 WHERE duration = "20 years" AND soap_opera = "home and away"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (actor VARCHAR, duration VARCHAR, soap_opera VARCHAR) Question: Which actor played on Home and Away for 20 years? [/INST] SELECT actor FROM table_name_21 WHERE duration = "20 years" AND soap_opera = "home and away" </s>