SELECT su.url_type, COUNT(*) AS total
FROM short_urls su
WHERE DATE(`added_on`)>='2017-12-01' AND DATE(`added_on`)<='2018-02-15'
GROUP BY su.url_type ORDER BY total DESC