LLC project post query

select day(created_at), monthname(created_at), count(*)
from post group by day(created_at), monthname(created_at)