Home | How it works | Projects archive | Contact Us
Air Compressor Bot 		 
The Career Path of Freelance Programming Jobs 

   SQL Questions
Bidding Time:
27/07/2006 23:33 - 28/07/2006 00:00
Budget:
$30-100
Status:
 Closed


Job Type:
N/A
Description:

$5.95 Web Hosting

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.
1.One 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.
2.Report the total revenue (total number of orders for the current month by
wholesaler).
3.Report the total revenue year-to-date for each wholesaler along with the
average monthly number of orders.
4.Report 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.
5.List all wholesalers with outstanding overdue payments. Show the total amount
that is overdue.
6.For all states, list the total number of wholesalers in each.
7.List 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.
8.An item is no longer being offered by KTC toys. Write a SQL statement to
delete the item number from the database.
9.The 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.)
10.List 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 questions.Attached is the database sturcture. My budget
is $20

Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
Print Marketing Sales
Link Building For Debt Site
Splash Page
Auto Adwords Bid Management
Fast loading FrontPage Template with unique cool graphic for affiliate site needed.

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
 (None)
Database System:
 (None)
<<< back

Recent Projects Archive:

Friday - Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday

View all freelance web projects
 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /0.578