Hi there, I hope your help.
This is my SQL server table:
MAT ENER1 ENER2 ENER3 ENER4 COD1 COD2 COD3 COD4
d 150 25 35 125 300 303 305 307
d 100 15 40 110 300 303 305 311
d 130 17 28 63 305 312 313 313
With query I need:
- Sum ENER1 when COD1 is in 300, 303, 305, 307, 309, 311, 313, 315;
- Sum ENER2 when COD2 is in 300, 303, 305, 307, 309, 311, 313, 315;
- Sum ENER3 when COD3 is in 300, 303, 305, 307, 309, 311, 313, 315;
- Sum ENER4 when COD4 is in 300, 303, 305, 307, 309, 311, 313, 315;
- General total [ENER1] + [ENER2] + [ENER3] + [ENER4].
Output:
MAT ENER1 ENER2 ENER3 ENER4 TOTAL
d 380 40 103 298 821
Can you help me?
Thank you in advance.