| |
|
|
Job Summary:
|
| |
| Job Type: |
Project |
| Budget: |
$ 20-100 |
| Required
Skills: |
,
,
,
|
| Attached
Files: |
(None) |
| |
|
| Status: |
Work Performed (selected user freshjah)
|
| |
|
|
|
Buyer Summary:
|
| |
| Username: |
|
| Feedback Score: |
 
1
reviews
|
| Award Reliability: |
1 posted 1 paid |
| |
|
| Location: |
Clolorado Springs, Colorado springs, United States
|
| Member Since: |
August 20, 2008 |
| |
|
|
|
| Invited Users: |
There are no invited users
|
Description
Description
10 SQL Statements
Details: From the requirements gathering sessions, your team knows that senior management expects to be able to keep a close watch on the toy sales. They will want to know the general revenue, the number of orders, the current number of wholesalers, the amount of outstanding accounts, and so on for all time periods.
Additionally, on a routine basis, the KTC system DB administrator will need to make routine updates to the database.
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.
Reminder
You may not start working in this and any request before
your bid is accepted. Users who violate this policy
may have their accounts permanently suspended.
|
|
|
|
| |
| Get the Free
Step-by-Step Guide on How to Use GetACoder |
The act of
outsourcing jobs has become easy in the past few years
thanks to GetACoder. However, our team aims at making the
whole process even easier. So, it has now come the time to
provide you with a step-by-step guidance on how to use this
service and succeed in the outsourcing world totally for
FREE.
It doesn't matter if you are a more experienced user or a
novice; using GetACoder will become even simpler with the
help of this E-book. There are two major sections: a Buyers
section and a Coders section.
Buyers will learn:
- How to outsource safely
- How to pick the best freelancers
- How to manage time and money
Coders will learn:
- How to get the best jobs
- How to secure their payments
- How to build a long-lasting relationship with buyers
...and MUCH MORE
Clear examples and pictures illustrating key situations,
great tips and real testimonies of some of our best users...
all in this Outsourcing Guide. So don't loose the
outstanding opportunity to download GetACoder FREE E-book.
|
 |
|
 GetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online. One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day. Thousands of Satisfied Customers - Submit/View Quotes
| - | A truely career starting site full of solutions for both clients and developers. - | | - | First experience using GetACoder.com and I'm really surprised and impressed. Dr. S.Ali - | | - | I like its user friendly features and also its simplicity make it a unique Marketplace. - |
|
|
| |
© 2004-2012 GetACoder. All rights reserved. |
|
