Which film or series was nominated in the category of best fansite?
CREATE TABLE table_name_2 (film_or_series VARCHAR, result VARCHAR, category VARCHAR)
SELECT film_or_series FROM table_name_2 WHERE result = "nominated" AND category = "best fansite"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (film_or_series VARCHAR, result VARCHAR, category VARCHAR) Question: Which film or series was nominated in the category of best fansite? [/INST] SELECT film_or_series FROM table_name_2 WHERE result = "nominated" AND category = "best fansite" </s>