title: SQL absolute value sum and iterate
body: <p>Lets say i have table with that looks something like this: <br/></p>
  <h1>cns_amt ---- cusip_nbr</h1>
  <p>-3000 -------------------- 00162Q205 <br/>
  4000 -------------------- 00162Q205 <br/>
  6000 -------------------- 00162Q205 <br/>
  8000 -------------------- 00162Q205 <br/>
  10000-------------------- 33733B100 <br/>
  -2900 -------------------- 33733B100 <br/>
  1000-------------------- 33733B100 <br/>
  8000 -------------------- 33733B100 <br/>
  7000-------------------- 464286178<br/>
  -1200 -------------------- 464286178<br/>
  1000-------------------- 464286178<br/>
  1000 -------------------- 464286178<br/></p>
  <p>How can I make it so I get the results:</p>
  <h1>total_amt ---- cusip_nbr <br/></h1>
  <p>21000------------------------00162Q205 <br/>
  21900-----------------------33733B100 <br/>
  10200------------------------4642861 <br/></p>
  <p>Basically I would like to sum each the absolute value for each distinct cusip_nbr and return a result that plots each cusip_nbr and its respective absolute value sum. (Only three distinct cusip_nbr 's are shown here but i have hundreds of them, each with a cns_amt that needs to be summed)</p>