Question: Queries: Query 1 - ( Select query ) Display the list of projects and their assigned employees and their working hours Query 2 - (
Queries:
Query Select query Display the list of projects and their assigned employees and their working hours
Query Total query Display the number of employees how many and total hours worked for each project
Query Update query Update employee working hours for over time if anybody worked more than hours on any project add to their working hours for the extra hours, eg an employee who worked hours, his working hours will be updated to
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
