a) Write a query to display the project tasks the scheduled start and end dates and the
Question:
a) Write a query to display the project tasks the scheduled start and end dates and the number of employees required to complete each task.
b) Write a query to display all employees (last and first name), employee hire date and skill description in each region. Sort by skill description within each region.
c) Write a query to display an inventory of the skills. Display a list of the skills and each employee (last and first name) having each skill. Sort by skill description.
d) Write a query to display total weekly hours in the work log. Display by week total number of hours worked by all employees. e) Write a query to display the total work log amount billed for each employee. Display the total dollar amount to be billed for each employee. Include employee name (last and first), total hours worked, task, skill description, skill rate of pay, and total amount. Group by task and display total dollar amount in descending order.
f) Write a query to display all the customers in each region. Sort by region then customer.
g) Write a query to display the total number of employees by skill description in each region.
h) Write a query to display all tasks for the project. Include the task scheduled start and end dates, required skills description, employee last and first names, and actual assigned start and end dates. Order by scheduled start dates.
i) Write a query to display the employees, dates worked, hours worked, assignment, task description, and skill description for each bill. Sort by task description.
j) Write a query to display the total hours worked and total amount billed for the project.
k) Write a query to display all employees (first and last name) on the project with more than 2 years' experience as of January 1, 2002.
l) Write a query to display all employees by region. Include region description, employee name (first and last), and employee hire date. Group by region.
m) Write a SELECT statement using a DATE/TIME function.
n) Write an INSERT statement.
o) Write an UPDATE statement.
p) Write a DELETE statement.
q) Write a trigger to update the work-log entries when a bill is written and sent to the customer for the total hours worked on the project during that period.
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris