MYSQL 查询 - 多个赞 [英] MYSQL query - multiple likes

问题描述

坚持这个查询.显然，我下面的内容是错误的，但希望它使我想要做的事情变得清晰.

Stuck on this query. Obviously what I have below is wrong but hopefully it makes what I'm trying to do clear.

SELECT branch, 
SUM(price * quantity) as "Office" FROM orders WHERE account LIKE "0%" 
and 
SUM(price * quantity) as Personal FROM orders WHERE account LIKE "1%" 
GROUP BY branch;

我确定我要离开这里了.

I'm sure I'm way off here.

谢谢

推荐答案

在每个 sum 中使用 case :

Use a case inside each sum:

select branch,
    sum(case when account like '0%' then price * quantity else 0 end) as Office,
    sum(case when account like '1%' then price * quantity else 0 end) as Personal
from orders
group by branch

这篇关于MYSQL 查询 - 多个赞的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！