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