How many artists are above age 46 and joined after 1990?
CREATE TABLE artist (age VARCHAR, year_join VARCHAR)
SELECT COUNT(*) FROM artist WHERE age > 46 AND year_join > 1990
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE artist (age VARCHAR, year_join VARCHAR) Question: How many artists are above age 46 and joined after 1990? [/INST] SELECT COUNT(*) FROM artist WHERE age > 46 AND year_join > 1990 </s>