Question: CSCI N 2 0 7 Lab Assignment TwoSQL Queries Use WPC 2 database and create a query for each of the following tasks . 1

CSCI N207 Lab Assignment TwoSQL Queries Use WPC2 database and create a query for each of the following tasks.1. Provide a list of projects that started on and after July 1st,2005. Don't need show project IDs or Departments or End Dates. (10)2. Find out which employees have no phone numbers. (20)3. Find the average hours worked for all employees. The result table should have just one row one column and should have a good column name. (20)4. Find out which departments are in building 01. The result should have department names and building names, sorted by department name in ascending order. (20)5. Display a list of employees (show names) with their hours worked, wage and bonus, for each project they worked on. Wage is calculated by hours worked times 10. Bonus is calculated by hours worked times 3. There will be duplicate names in the query result, since an employee can work on multiple projects. (20)SubmissionAll the queries should have good naming conventions and meaningful query names. Each query should start with its task number. e.g. a good query name for task one can be 1ProjectsOnAfterJulyFirst2005. Change the database file name to yourlastname_Lab2.accdb. (10)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!