CODE EXAMPLE FOR SQL

mysql last 7 days including today

SELECT * FROM `account` 
WHERE DATE(created_at) > (NOW() - INTERVAL 7 DAY)