날짜별 검색 쿼리

select date_format(created, '%Y-%m-%d') as date, count(*) as village_count
from xxxxx
where created > date_format(date_add(now(), interval -1 month), '%Y-%m-%d')
group by date_format(created, '%Y-%m-%d')
order by date_format(created, '%Y-%m-%d') desc