instruction: R versus Python tags - quotient Py/R.
response: SELECT DATE(CAST(t.yr AS TEXT(4)) + '-' + CAST(t.mnth AS TEXT(2)) + '-01') AS dt, (CASE WHEN t.r_mnth_count = 0 THEN NULL ELSE CAST(t.py_mnth_count AS FLOAT) / CAST(t.r_mnth_count AS FLOAT) END) AS py_div_r FROM (SELECT MONTH(CreationDate) AS mnth, YEAR(CreationDate) AS yr, SUM(CASE WHEN Tags LIKE '%<r>%' THEN 1 ELSE 0 END) AS r_mnth_count, SUM(CASE WHEN Tags LIKE '%<python>%' THEN 1 ELSE 0 END) AS py_mnth_count FROM Posts WHERE Tags LIKE '%<r>%' OR Tags LIKE '%<python>%' GROUP BY MONTH(CreationDate), YEAR(CreationDate)) AS t WHERE NOT (t.mnth = MONTH(CURRENT_TIMESTAMP()) AND t.yr = YEAR(CURRENT_TIMESTAMP())) AND yr >= 2014 ORDER BY t.yr, t.mnth