SELECT agent_no,name,email,phone_no,address1,address2,city,state,postcode,created_at FROM agent_signup WHERE DATE(created_at) <= SUBDATE(CURRENT_DATE(),1) AND DATE(created_at) >= SUBDATE(CURRENT_DATE(),INTERVAL 1 WEEK);