Group by week:
select COUNT(id) as total_count, WEEKOFYEAR(created_at) AS yr_week from analytics where
is_redeemed = 1 and created_at >= NOW() - INTERVAL 7 WEEK group by yr_week
Group by month:
select COUNT(id) as total_count, MONTH(created_at) AS yr_week from analytics where
is_redeemed = 1 and created_at >= NOW() - INTERVAL 3 MONTH group by yr_week
More from my site
-
Batch update in php mysql
-
Second Highest Salary without subquery in MySQL | Nth highest Salary without subquery | MySQL second highest salary query
-
Left join with last record of right table in Laravel & Mysql
-
if else and case when in Laravel query
-
How to update php 7 on OSX
-
How to delete duplicate records from MySQL table | MySQL query to delete duplicate records