每月和每周的MySql时间戳查询和比较

i have a table where i enter entries for applicants. it has a column date_added where the type is timestamp and the default is current_timestamp. i want to make a weekly and monthly report but i can't decide what would be the best thing to do. i need an sql statement that return the number of entry like this..i have a table where i enter entries for applic