Select
COUNT(is_send) as Review_Emails_Sent,
SUM(is_open) as Review_Emails_Open
FROM review_emails
WHERE DATE(created_at) >= DATE_SUB(DATE(NOW()), INTERVAL 7 DAY)
AND DATE(created_at) < DATE(NOW());