这是我的查询:
SELECT claims.id,
COUNT(CASE WHEN claims.sold_at BETWEEN (now() - INTERVAL '7.day') AND now() END FROM claims) week1
FROM users
LEFT JOIN claims ON claims.sales_user_id = users.id
WHERE users.office_id = 2
我想要做的是加入索赔表,然后还获得在特定日期范围内卖出的数量的计数
此查询给出了一个错误,但不确定如何正确解决/处理它?
最佳答案
尝试这个:
select
users.id, count(claims.id) as count
from users
left join claims on claims.sales_user_id = users.id
where
users.office_id = 2 and
claims.sold_at between (current_timestamp - interval '7' day) and current_timestamp
group by users.id;
关于mysql - 如何通过条件计算从左连接开始的行数,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/33416632/