Q Let’s extend the WorksOn table that we discussed in the class by adding an additional column hours. The hours column is used to keep track of the amount of time a person has worked on a project. An example of the extended WorksOn table is shown below:
Create the alter table statements and theInsert statements
Write a SQL Statement to retrieve all the people who work on the same projects as smith with the same amount of hours with respect to each Project. With the sample data only smith and brown should be retrieved Oaks is disqualified since Oaks has worked on Project Y for 10 hours only (instead of 20 as smith has)
Create the alter table statements and theInsert statements
Write a SQL Statement to retrieve all the people who work on the same projects as smith with the same amount of hours with respect to each Project. With the sample data only smith and brown should be retrieved Oaks is disqualified since Oaks has worked on Project Y for 10 hours only (instead of 20 as smith has)
