What's the highest league of the Nova Scotia Clippers with a total season of less than 4?
CREATE TABLE table_name_2 (highest_league VARCHAR, total_seasons VARCHAR, team VARCHAR)
SELECT highest_league FROM table_name_2 WHERE total_seasons < 4 AND team = "nova scotia clippers"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (highest_league VARCHAR, total_seasons VARCHAR, team VARCHAR) Question: What's the highest league of the Nova Scotia Clippers with a total season of less than 4? [/INST] SELECT highest_league FROM table_name_2 WHERE total_seasons < 4 AND team = "nova scotia clippers" </s>