这是我的查询,需要修改以反映时间过滤器:
SELECT DATE AS TIME,mbps
FROM overage
WHERE DATE >= (CASE WHEN (DAY(CURDATE()) = 1 OR DAY(CURDATE()) = 2 OR DAY(CURDATE()) = 3 OR DAY(CURDATE()) = 4) THEN CONCAT(YEAR(CURDATE()),'-', MONTH(CURDATE() - INTERVAL 1 MONTH),'-04') ELSE CONCAT(YEAR(CURDATE()),'-', MONTH(CURDATE()),'-04') END) AND DATE <= (CURDATE() - INTERVAL 1 DAY)
ORDER BY DATE