SQL: different aggregate values for different condition

Question

I have such a difficult problem from my knowledge.

I need to write a sole query that perform this action:

write a query that for the day Monday extract the sum of computer sold, and for the rest of the days just the sum of Laptop.

For example I have this table

Day      LaptopSold DesktopSold Total
Monday      2            2        4
Tuesday     2            3        5
Monday      1            1        2
Wednesday   2            2        4
Tuesday     1            4        5

The result should be this:

Day       QtySold
Monday      6
Tuesday     3
wed         2

I can achieve the goal just writing two separate queries with the Group By for the Day field, but in one query for me is impossible!!!

Could you help me, please!!! Thanks in advance Lu

How does the Monday value equal six (6)? Shouldn't it be two (2)? — BellevueBob
– BellevueBob, Commented Sep 2, 2013 at 16:37
@BellevueBob There is 2 lines that having Monday as day...and for monday you need to look at the total column :) — Fabien TheSolution
– Fabien TheSolution, Commented Sep 2, 2013 at 16:46

Gidil · Accepted Answer · 2013-09-02 16:40:10Z

4

You can select the additive field with a CASE:

SELECT DAY, 
       SUM(CASE DAY 
             WHEN 'MONDAY' THEN TOTAL 
             ELSE LAPTOPSOLD 
           END) AS QtySold 
FROM   TBL 
GROUP  BY DAY

edited Sep 2, 2013 at 16:40

Gidil

4,1472 gold badges38 silver badges50 bronze badges

answered Sep 2, 2013 at 16:36

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL: different aggregate values for different condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related