Which NGC number has a Constellation of ursa major?
CREATE TABLE table_name_1 (ngc_number INTEGER, constellation VARCHAR)
SELECT MAX(ngc_number) FROM table_name_1 WHERE constellation = "ursa major"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (ngc_number INTEGER, constellation VARCHAR) Question: Which NGC number has a Constellation of ursa major? [/INST] SELECT MAX(ngc_number) FROM table_name_1 WHERE constellation = "ursa major" </s>