What is the highest Z (p) when the N (n) is less than 30, and scandium is the element?
CREATE TABLE table_name_37 (z___p__ INTEGER, n___n__ VARCHAR, element VARCHAR)
SELECT AVG(z___p__) FROM table_name_37 WHERE n___n__ < 30 AND element = "scandium"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_37 (z___p__ INTEGER, n___n__ VARCHAR, element VARCHAR) Question: What is the highest Z (p) when the N (n) is less than 30, and scandium is the element? [/INST] SELECT AVG(z___p__) FROM table_name_37 WHERE n___n__ < 30 AND element = "scandium" </s>