WITH t AS
(
SELECT 1 id, '20140701' dt, '09' stm, '11' etm
UNION ALL SELECT 2, '20140701', '09', '10'
UNION ALL SELECT 3, '20140701', '10', '12'
UNION ALL SELECT 4, '20140702', '09', '12'
)
SELECT dt
     , COUNT(CASE WHEN '09' BETWEEN stm AND etm THEN 1 END) "09"
     , COUNT(CASE WHEN '10' BETWEEN stm AND etm THEN 1 END) "10"
     , COUNT(CASE WHEN '11' BETWEEN stm AND etm THEN 1 END) "11"
     , COUNT(CASE WHEN '12' BETWEEN stm AND etm THEN 1 END) "12"
  FROM t
 GROUP BY dt
;