Find the total number of tours for each ranking date.
CREATE TABLE rankings (ranking_date VARCHAR, tours INTEGER)
SELECT SUM(tours), ranking_date FROM rankings GROUP BY ranking_date
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE rankings (ranking_date VARCHAR, tours INTEGER) Question: Find the total number of tours for each ranking date. [/INST] SELECT SUM(tours), ranking_date FROM rankings GROUP BY ranking_date </s>