What is the Award, when the Film/Show is East West 101, and when the year is before 2009, and when the Group is Logie Award?
CREATE TABLE table_name_96 (award VARCHAR, group VARCHAR, film_show VARCHAR, year VARCHAR)
SELECT award FROM table_name_96 WHERE film_show = "east west 101" AND year < 2009 AND group = "logie award"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (award VARCHAR, group VARCHAR, film_show VARCHAR, year VARCHAR) Question: What is the Award, when the Film/Show is East West 101, and when the year is before 2009, and when the Group is Logie Award? [/INST] SELECT award FROM table_name_96 WHERE film_show = "east west 101" AND year < 2009 AND group = "logie award" </s>