I need some SQL statement help Here is the following situati

I need some SQL statement help.

Here is the following situation I need help with.

Select the total amount paid out for each project. Use a Group By clause and include the name of each project in your results.

EMP NO EMP FNAME EMPLNAME Cs 9 EMP STATUS EMP SALARY EMP COMM EMP-HIREDATE EMP MGR EMP NO JOB TITLE DEPTNO FLIGHTS JOB JOB TITLE SALG GRADE PILOTS PROJECT PROJ NO PROJ NAME PROJ VALUE EMP-NO SALGRADE SALG GRADE SALG LOSAL SALG HISAL EL , H

Solution

Select PROJ_NAME,SUM(PROJ_VALUE) AS TOTALCOST From PROJECT GROUP BY PROJ_NO;

Sum is the aggregate function to sum all the values for a project number. Group By clause is used with aggregate functions for grouping of data and apply the function.