What are the maximum and minimum share of performances whose type is not "Live final".
CREATE TABLE performance (SHARE INTEGER, TYPE VARCHAR)
SELECT MAX(SHARE), MIN(SHARE) FROM performance WHERE TYPE <> "Live final"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE performance (SHARE INTEGER, TYPE VARCHAR) Question: What are the maximum and minimum share of performances whose type is not "Live final". [/INST] SELECT MAX(SHARE), MIN(SHARE) FROM performance WHERE TYPE <> "Live final" </s>