What is the promotion when the arena was the venue and the event of legends of the arena?
CREATE TABLE table_name_4 (promotion VARCHAR, venue VARCHAR, event VARCHAR)
SELECT promotion FROM table_name_4 WHERE venue = "the arena" AND event = "legends of the arena"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (promotion VARCHAR, venue VARCHAR, event VARCHAR) Question: What is the promotion when the arena was the venue and the event of legends of the arena? [/INST] SELECT promotion FROM table_name_4 WHERE venue = "the arena" AND event = "legends of the arena" </s>