Hi,
I am pretty new to sql script in hana . I have a requirement in which i have to write a sql script on the below conditions.
Category
type
east
west
North
South
central
others
10
100
100
200
300
400
500
890
10
200
100
200
300
400
500
890
20
300
200
300
400
500
890
500
10
100
100
200
300
400
500
890
20
200
200
300
400
500
890
500
10
300
100
200
300
400
500
890
20
100
200
300
400
500
890
500
1- check for types (100, 200, 300)
2-. If type 100, read all the rates east,west,north,south,central
sum it and sent it back to some output a1
3-. If type 200 or 300, then read other... sum it and sent back to some output b1
Regards,
Richard