would anyone please help me to translate this query to sql. thank in advance
riv:report10 | LMS_DRG |COUNT |WEIGHT
|_a |_b |_c
riv:report |DRG |Reassignment |Reasignment_Weight
|_a |_d, changeTo _b+_d |_e, Changeto ((-1)*_c)+_e