What is the number of guests for the Viking Ingvar, built earlier than 1990?
CREATE TABLE table_name_46 (guests INTEGER, ship_name VARCHAR, year_built VARCHAR)
SELECT AVG(guests) FROM table_name_46 WHERE ship_name = "viking ingvar" AND year_built < 1990
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (guests INTEGER, ship_name VARCHAR, year_built VARCHAR) Question: What is the number of guests for the Viking Ingvar, built earlier than 1990? [/INST] SELECT AVG(guests) FROM table_name_46 WHERE ship_name = "viking ingvar" AND year_built < 1990 </s>