select ev.EVENT_ID, ev.LOCATION, SUM(s.HOURLY_RATE) cost from EVENT_STAFF es left join event ev on ev.EVENT_ID = es.EVENT_ID left join staff s on s.ssn = es.SSN group by ev.EVENT_ID , ev.location order by ev.EVENT_ID
SELECT LOCATION, TOTAL_COST FROM ( SELECT ES.EVENT_ID, SUM(HOURLY_RATE) TOTAL_COST FROM EVENT_STAFF ES INNER JOIN STAFF S ON ES.SSN = S.SSN GROUP BY ES.EVENT_ID ) T INNER JOIN EVENT E ON T.EVENT_ID = E.EVENT_ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)