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 N Lab Assignment TwoSQL Queries Use WPC database and create a query for each of the following tasks Provide a list of projects that started on and after July st Don't need show project IDs or Departments or End Dates. Find out which employees have no phone numbers. 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. Find out which departments are in building The result should have department names and building names, sorted by department name in ascending order. 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 Bonus is calculated by hours worked times There will be duplicate names in the query result, since an employee can work on multiple projects. SubmissionAll the queries should have good naming conventions and meaningful query names. Each query should start with its task number. eg a good query name for task one can be ProjectsOnAfterJulyFirst Change the database file name to yourlastnameLabaccdb.
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
