我有下表优化
select items_type,
created_at,
count_optimized_items
from optimizations
where shop_id=126
and count_optimized_items!=0
项目类型 | 创建时间 | count_optimized_items |
---|---|---|
4个 | 2023-04-20 06:49:00 | 1个 |
2个 | 2023-04-20 06:49:00 | 1个 |
1个 | 2023-04-20 06:48:59 | 50 |
5个 | 2023-04-20 06:48:59 | 170 |
5个 | 2023-04-21 07:00:42 | 212 |
5个 | 2023-04-20 07:14:54 | 147 |
5个 | 2023-04-20 07:25:31 | 210 |
5个 | 2023-04-20 07:39:33 | 193 |
5个 | 2023-04-20 07:52:41 | 102 |
现在我想根据 items_type 和 date 分组并获得 count_optimized_irems 的总和
select name,
shop_id,
items_type,
created_at,
count_optimized_items,
sum(count_optimized_items) as sum_count
from metadata_optimizations
where shop_id=126
and count_optimized_items!=0
group by created_at,items_type
我尝试了上面的查询,但它不起作用
这是预期的结果
项目类型 | 创建时间 | count_optimized_items |
---|---|---|
4个 | 2023-04-20 06:49:00 | 1个 |
2个 | 2023-04-20 06:49:00 | 1个 |
1个 | 2023-04-20 06:48:59 | 50 |
5个 | 2023-04-20 06:48:59 | 822 |
5个 | 2023-04-21 07:00:42 | 212 |
基本上是基于日期和项目类型的 count_optimized_items 总和