sql

SELECT
	DATE( create_time ) AS date,
	COUNT( 1 ) AS count 
FROM
hipster_runtime_v4.r_task_center
WHERE
	DATE_SUB( CURDATE( ), INTERVAL 7 DAY ) <= DATE( create_time ) and scenario_no='201'
GROUP BY
	date;