title: SELECT with where clause condition
body: <p>In my sql oracle table i have something like this</p>
  
  <pre><code>CREATE TABLE Project (
  P#      NUMBER(10)  NOT NULL, /* Project number     */
  PTitle      VARCHAR2(30)    NOT NULL, /* Project title      */
  Sponsor     VARCHAR2(30),         /* Project sponsor name   */
  D#      NUMBER(5)   NOT NULL, /* Department number      */
  Budget      NUMBER(10,2)    NOT NULL, /* Project budget     */
  CONSTRAINT Project_PK PRIMARY KEY(P#),
  CONSTRAINT Project_FK FOREIGN KEY (D#) REFERENCES Department(D#),
  CONSTRAINT Project_CK UNIQUE (PTitle)
  );
  
  INSERT INTO Project VALUES (1001, 'Computation', 'Microsoft', 1, 25000);
  INSERT INTO Project VALUES (1002, 'Study methods', 'Education committee', 3, 15000);
  INSERT INTO Project VALUES (1003, 'Racing car', 'Cloud Pty Ltd', 3, 225000);
  INSERT INTO Project VALUES (1004, 'Football', 'Football club', 5, 35000);
  INSERT INTO Project VALUES (1005, 'Swimming', 'Education committee', 5, 125000);
  </code></pre>
  
  <p>I have to SELECT the sponsor name and total_budget for each sponsor .
  so when i SELECT SPONSOR,BUDGET. what condition should i put in order the Education commitee only show once time and the budget only show (15000+125000)= 140000 ?
  the output should be something like</p>
  
  <pre><code> SPONSOR           total_budget
   -------------------------------
  Education Commitee    140000
  Cloud Pty Ltd         225000
  etc....
  </code></pre>