The project manager has asked you begin the back-end work for the reporting and query tools and to submit it to him in a Word Document as soon as possible. Using MS Access, write SQL statements for the items listed below or explain why a SQL statement could not be executed without risk to the relational integrity of the database.
[url removed, login to view] of the wholesalers has merged with another company, and the company name has changed. Example: LearningToys has changed to LightBright Toys. Write a SQL statement to change the name accordingly.
[url removed, login to view] the total revenue (total number of orders for the current month by wholesaler).
[url removed, login to view] the total revenue year-to-date for each wholesaler along with the average monthly number of orders.
[url removed, login to view] all products ordered and revenue for the current month as well as a running year-to-date total. List these in descending order by current month revenue.
[url removed, login to view] all wholesalers with outstanding overdue payments. Show the total amount that is overdue.
[url removed, login to view] all states, list the total number of wholesalers in each.
[url removed, login to view] all KTC sales alphabetically. For each employee, show the number of wholesalers that placed orders with them for the current month, the average number of orders by wholesaler, and the total revenue that month.
[url removed, login to view] item is no longer being offered by KTC toys. Write a SQL statement to delete the item number from the database.
[url removed, login to view] KTC marketing department wants to do a special promotion and needs a list of all wholesaler contacts who have ordered at least 20 of item # X but have not ordered item # Y in the past 6 months. (Choose a value for X and Y for your SQL statement.)
[url removed, login to view] the items in descending order by revenue of the orders that were backordered YTD. Show the total amount of revenue for items that were backordered. List the items and their associated revenue again in a second list if the order that was backordered was deleted.
p[lease answer the above [url removed, login to view] is the database sturcture. My budget is $20