title: POSTGRESQL: Sum a field when 2 condtions are met
body: <p>I wonder if i could get some help with this.</p>
  
  <p>I have a query im trying to write in the query i use 3 fields: ID, Option and amount.</p>
  
  <p>I need to group my unique ID's then in that Group i need to split up by option white totaling the amounts per option.</p>
  
  <p>eg: 
  ID: 11111 
  --> OptionA 500
  --> OptionB 100</p>
  
  <hr>
  
  <p>ID: 11112
  --> OptionA 150
  --> OptionB 100
  etc....</p>
  
  <p>Hope i was discriptive enough :)</p>
  
  <p>Appreciate the help.</p>