14 Extra Credit Question (5 Points) Write a query to get the sum of negative and

Question

14 Extra Credit Question (5 Points) Write a query to get the sum of negative and positive number in table Input Script drop table if exists numbers; Create table numbers (num int, cat int) insert into numbers values(1,1); insert into numbers values(2,1); insert into numbers values(-3,1); insert into numbers values(4,1); insert into numbers values(5,1); insert into numbers values(-2,2); insert into numbers values(-10,2); insert into numbers values(-5,2) insert into numbers values (12,2); insert into numbers values (13,2); Expected output: NegSum Pos sum 37 -20

Explanation / Answer

Hi, the query for it will be:

mysql> select (select sum(num) from numbers where num>0) as Pos_sum, (select sum(num) from numbers where num<0) as Neg_sum from dual;

Here we have used subqueries and alias. And, dual is the dummy database.

Kindly let me know if you have any doubts in it!

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---