Task: Text to Code
Input (English): Find the total number of tours for each ranking date.
Output (English): SELECT sum(tours) ,  ranking_date FROM rankings GROUP BY ranking_date