Write SQL Queries for the following:
Cust
Cust_ID
Name
1
AA
2
BB
3
CC
4
DD
5
EE
Ord
Ord_ID
Cust_ID
Amt
Tran_Type
From_Ord_ID
1
1
10
D
NULL
2
1
20
D
NULL
3
2
30
D
NULL
4
2
40
D
NULL
5
2
NULL
D
NULL
6
3
NULL
D
NULL
7
4
40
D
NULL
8
4
50
D
NULL
9
4
-10
C
7
10
4
-20
C
8
11
4
-30
C
8
<!--[endif]-->Write a query that shows the balance for customer DD by trans_type. Consider a Tran_type of “C” to be a transactional adjustment to the associated original “D” record. The result should be as follows.
Name
D
C
Balance
DD
40
-10
30
(It looks like that time of year again, when we start getting requests to do class assignments.)
Subhash,
Please post the efforts you have made up to now, and we can help guide you to a correct solution. I just don't think that you will find folks here willing to do your classwork for you. Also post the table DDL, and sample data in the form of INSERT statements. If you need help with that concept, check here or here.
|||hahaha.
well its actually easy. you need to use join
and sum function and group by
sql
No comments:
Post a Comment