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"
### Context: CREATE TABLE performance (SHARE INTEGER, TYPE VARCHAR) ### Question: What are the maximum and minimum share of performances whose type is not "Live final". ### Answer: SELECT MAX(SHARE), MIN(SHARE) FROM performance WHERE TYPE <> "Live final"