这是我的查询:

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/

10-12 14:17
查看更多