---------------------------------------------------------------------------
select title as project, lastname as employee, noofhoursperweek/40*salary as cost
from employee e
join empproj ep on ep.eid=e.eid
join project p on p.pid=ep.pid
order by project, employee;
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------