How many times was revenue in millions recorded when the spending per capita was $6,736?
CREATE TABLE table_14700336_1 (revenue__millions_ VARCHAR, spending_per_capita VARCHAR)
SELECT COUNT(revenue__millions_) FROM table_14700336_1 WHERE spending_per_capita = "$6,736"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_14700336_1 (revenue__millions_ VARCHAR, spending_per_capita VARCHAR) Question: How many times was revenue in millions recorded when the spending per capita was $6,736? [/INST] SELECT COUNT(revenue__millions_) FROM table_14700336_1 WHERE spending_per_capita = "$6,736" </s>