What is the location that has a date of demolition of 1940 and has a church named Christ Church Greyfriars?
CREATE TABLE table_name_46 (location VARCHAR, date_of_demolition VARCHAR, church_name VARCHAR)
SELECT location FROM table_name_46 WHERE date_of_demolition = 1940 AND church_name = "christ church greyfriars"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (location VARCHAR, date_of_demolition VARCHAR, church_name VARCHAR) Question: What is the location that has a date of demolition of 1940 and has a church named Christ Church Greyfriars? [/INST] SELECT location FROM table_name_46 WHERE date_of_demolition = 1940 AND church_name = "christ church greyfriars" </s>