How many votes did 3rd ranking candidate Mary Louise Lorefice receive?
CREATE TABLE table_name_48 (votes VARCHAR, rank VARCHAR, candidate VARCHAR)
SELECT COUNT(votes) FROM table_name_48 WHERE rank = "3rd" AND candidate = "mary louise lorefice"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (votes VARCHAR, rank VARCHAR, candidate VARCHAR) Question: How many votes did 3rd ranking candidate Mary Louise Lorefice receive? [/INST] SELECT COUNT(votes) FROM table_name_48 WHERE rank = "3rd" AND candidate = "mary louise lorefice" </s>