6317 SQL statements

Answer the following 10 questions,database structure is [url removed, login to view] budget is $15-20 [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. 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.

Taidot: kaikki käy, Microsoft Access, SQL

Näytä lisää: write toys, wholesalers c&a, needs and wants in marketing, marketing needs and wants, explain needs in marketing, sql microsoft access, sql marketing, ms access sql, microsoft access sql, wants needs in marketing, toys 4, statements, sql microsoft, sql database report, SQL Access, report sql, access to sql, access sql, company wants marketing, statement structure sql, access delete, relational database microsoft access, sales report access, write relational database, sql report write

Tietoa työnantajasta:
( 1 arvostelu )

Projektin tunnus: #1757187

Myönnetty käyttäjälle:


I can do it. but dont forget attach db structure

20 $ USD 1 päivässä
(3 arvostelua)