SQL Questions by jenma05
Required skills: 76870
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
Additional files submitted:
Project Information.zip
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
Additional files submitted:
Project Information.zip
Posted In: |
Related projects:
SQL QUESTIONS
br>
Additional files submitted:
sql_logbook.rar
Attachement.txt
Additional files submitted:
sql_logbook.rar
Attachement.txt
Display User Ms Sql Content In Drupal 6.x
in Baltimore, Maryland and Washington, DC.
- 100% of the fee for the project will be placed into Escrow immediately upon choosing a winning bid.
- When responding with a bid, please show examples of similar work (e.g. Drupal/databse work) that will demonstrate your ability to complete the project successfully.
- This is the first of several Drupal/database projects we need completed. The winning bidder will be heavily considered for all future work as well.
- 100% of the fee for the project will be placed into Escrow immediately upon choosing a winning bid.
- When responding with a bid, please show examples of similar work (e.g. Drupal/databse work) that will demonstrate your ability to complete the project successfully.
- This is the first of several Drupal/database projects we need completed. The winning bidder will be heavily considered for all future work as well.
Database Expert to Answer 7 PL/SQL Questions ASAP!
simple SQL queries
4 are PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers.
I will provide you with the database in text files.
This should not take an expert more than 4 hours to complete.
You have to explain to me how to excecute the SQL and PL/SQL.
The budget is $ 20 - $ 30.
I want this done quick so only fast workers please.
4 are PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers.
I will provide you with the database in text files.
This should not take an expert more than 4 hours to complete.
You have to explain to me how to excecute the SQL and PL/SQL.
The budget is $ 20 - $ 30.
I want this done quick so only fast workers please.
Sql Questions
I need sql exam questions multiple choice (5 choice)
I need about 50 questions.
PM me for details.
Need it urgent.
I need about 50 questions.
PM me for details.
Need it urgent.
5 SQL Questions
Hello guys,
On that page http://sqlzoo.net/a1d.htm there are 5 questions for SQL.
Can someone to answer them correct?
thanks.
On that page http://sqlzoo.net/a1d.htm there are 5 questions for SQL.
Can someone to answer them correct?
thanks.
Add SQL Builder feature to existing windows form application
e the following experience:
1. Excellent expereince and knowledge using C#, Visiual Studio 2007 - 2010 to develop windows forms.
2. Must have SQL Server experience
3. Peferred to hire someone who has already completed a similuar project.
4. Must write clean and efficent code. All code will be review by a senior developer.
5. The selected developer will be provided with a minimized version of the DataDQ application.
1. Excellent expereince and knowledge using C#, Visiual Studio 2007 - 2010 to develop windows forms.
2. Must have SQL Server experience
3. Peferred to hire someone who has already completed a similuar project.
4. Must write clean and efficent code. All code will be review by a senior developer.
5. The selected developer will be provided with a minimized version of the DataDQ application.
4 Simple Database/SQL Questions
ed
THIS SHOULD ONLY TAKE LESS THAN A HOUR
Additional files submitted: (Files are only available for logged in users)
DATAQuestions.doc
THIS SHOULD ONLY TAKE LESS THAN A HOUR
Additional files submitted: (Files are only available for logged in users)
DATAQuestions.doc
Complete a Simple SQL/Oracle database (College Assigment)
tored procedures) with comments to explain what each part of the codes does.
So basically the ER Diagrams and the database has already been made. You just have to check what i have done is correct, discuss with me and make changes. Then do the 3 sql queries and the 3 PL/sql.
I want this completed in two days and it shouldnt take a pro longer, so bids should be $ 20 max .
Thanks
So basically the ER Diagrams and the database has already been made. You just have to check what i have done is correct, discuss with me and make changes. Then do the 3 sql queries and the 3 PL/sql.
I want this completed in two days and it shouldnt take a pro longer, so bids should be $ 20 max .
Thanks
XML to SQL tables - SQL 2005 stored procedure
is a small project and experience developer can finish this in couple hours. Budget is @ $ 50.
Additional files submitted:
test.xml
Additional files submitted:
test.xml
Link Mssql Db To Drupal 6.x
Drupal user should then be able to view the entire payment ledger in the database.
My apologies that this description is not more technical.
Please, ask all the questions you'd like in order to make an educated bid. A sample of the MS SQL database is attached.
I would like this project to start as soon as possible.
Required:
Drupal 6.x
MS SQL
PHP
Views 2 module suggested, but alternatives will happily be considered
My apologies that this description is not more technical.
Please, ask all the questions you'd like in order to make an educated bid. A sample of the MS SQL database is attached.
I would like this project to start as soon as possible.
Required:
Drupal 6.x
MS SQL
PHP
Views 2 module suggested, but alternatives will happily be considered
Sql Order By Fix
_MEAS AS ITEM_SALES_MEASURE
FROM ITEMS,CATEGORY
WHERE ITEMS.ACTIVE = 'T' AND ITEMS.WEB_ACTIVE = 'T'
AND (ITEMS.MATRIX_ITEM_TYPE = '0' OR ITEMS.MATRIX_ITEM_TYPE = '1' OR ITEMS.MATRIX_ITEM_TYPE = '3') AND ITEMS.bRAND = 'SOLESU' AND (CATEGORY.PARENTCAT = 'BEMEN' ) AND ITEMS.CATEGORY = CATEGORY.CATEGORY AND ITEMS.CATEGORY != 'BENAM')
order ITEM_NO
I need someone to help me fix the order by to sort this varchar ALPHANUMERIc field naturally.
FROM ITEMS,CATEGORY
WHERE ITEMS.ACTIVE = 'T' AND ITEMS.WEB_ACTIVE = 'T'
AND (ITEMS.MATRIX_ITEM_TYPE = '0' OR ITEMS.MATRIX_ITEM_TYPE = '1' OR ITEMS.MATRIX_ITEM_TYPE = '3') AND ITEMS.bRAND = 'SOLESU' AND (CATEGORY.PARENTCAT = 'BEMEN' ) AND ITEMS.CATEGORY = CATEGORY.CATEGORY AND ITEMS.CATEGORY != 'BENAM')
order ITEM_NO
I need someone to help me fix the order by to sort this varchar ALPHANUMERIc field naturally.
Help in writing SQL statements
you to always answer within the stated time period but on average it should be the objective. I will pay 20% of the amount you bid after each 1 hour spend for supporting me.
In the future I might also have questions about Perl and PHP, so if you are skilled in these as well, please mention it. But it is not required for this project.
Important: If you are seriously interested in this project, please mention briefly which kind of experience you have.
In the future I might also have questions about Perl and PHP, so if you are skilled in these as well, please mention it. But it is not required for this project.
Important: If you are seriously interested in this project, please mention briefly which kind of experience you have.
sql ten questions by satttt
10 questions
Math Questions GMAT Style 300 Questions by TTGGFL
CH statement ALONE is sufficient to answer the question;
E if the two statements TAKEN TOGETHER are still NOT sufficient to answer the question.
To the bidders:
All work will be treated as Work for Hire. All copyrights will be transferred from the author(s) - the winning bidder - to the buyer (us). If this is not acceptable to you, do NOT bid.
Do not plagiarize. We reiterate that the work has to be original.
Thanks, and happy bidding.
E if the two statements TAKEN TOGETHER are still NOT sufficient to answer the question.
To the bidders:
All work will be treated as Work for Hire. All copyrights will be transferred from the author(s) - the winning bidder - to the buyer (us). If this is not acceptable to you, do NOT bid.
Do not plagiarize. We reiterate that the work has to be original.
Thanks, and happy bidding.
100 Unique GMAT Questions by TTGGFL
l have an excellent command in the English language, be very well read, and quite imaginative. In addition, the winning bidder should have an ideas of the subjects usually tackled by the GMAT preparers for such type of questions - like astronomy, history, business, biology, etc.
If there are any questions, please PM me. Make sure you send me samples of work if you have any. Final payment will be made only after all the 100 questions are read and approved.
If there are any questions, please PM me. Make sure you send me samples of work if you have any. Final payment will be made only after all the 100 questions are read and approved.
Researcher/Writer - 50 Questions by topicinfo
which questions are appropriate.
I will setup a login for you on my blog so you can post the questions yourself.
You will need to set each question to be posted one day apart.
They must be original content.
They only need be one to three sentences long.
You don't need any special skills. You simply need to have the time to think of 50 intelligent questions about muscle gain, fat loss, fitness, eating correctly, supplements etc.
I will setup a login for you on my blog so you can post the questions yourself.
You will need to set each question to be posted one day apart.
They must be original content.
They only need be one to three sentences long.
You don't need any special skills. You simply need to have the time to think of 50 intelligent questions about muscle gain, fat loss, fitness, eating correctly, supplements etc.
Inserting multiple records using excel and sql db. by stephenhol
the customization was not possible.
I am looking for a kind of plug-in which will help the user to automatically upload the information to the database. The solution needs to be highly user-friendly. It would be great if the user can select the database columns in which records from Excel need to be insert. This is not a pre, but recommendable.
Proposal
If you are interested, could you send me a proposal how you would do this and what it will cost.
I am looking for a kind of plug-in which will help the user to automatically upload the information to the database. The solution needs to be highly user-friendly. It would be great if the user can select the database columns in which records from Excel need to be insert. This is not a pre, but recommendable.
Proposal
If you are interested, could you send me a proposal how you would do this and what it will cost.
1064 - You have an error in your SQL syntax; by fishmonger
ot.orders_id), orders_status s where o.customers_id = '9' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20
I do not receive order information or payment.
Additional information submitted: 08/09/2006 at 8:44 EDT:
A few of the orders come through as they should, but the majority do not.
I do not receive order information or payment.
Additional information submitted: 08/09/2006 at 8:44 EDT:
A few of the orders come through as they should, but the majority do not.
ASP Online Exam System by sapgaurav
ards
About Reward Points
Recommend Friend
View Current Reward Point
Feedback
Add comments in testimonial
Other
Contact Us
Promotions
Books
Life Insurance
new1
fdgfdg
internet forum
Money1
testbok
commerce
Real Estate
gre
sd
Photshop
Additional files submitted:
EXAM_SW.doc
About Reward Points
Recommend Friend
View Current Reward Point
Feedback
Add comments in testimonial
Other
Contact Us
Promotions
Books
Life Insurance
new1
fdgfdg
internet forum
Money1
testbok
commerce
Real Estate
gre
sd
Photshop
Additional files submitted:
EXAM_SW.doc
Blackberry/SQL Dispatch by nologyadmin
vers by email over Blackberry/Exchange backend.
Using the browser, the driver accepts the order when received, marks picked up, marks delivered, and enters the signing person's name. Everything is time stamped.
The browser is too slow. We need an application written for the Blackberry 7250 (J2ME?) that will utiulize the push/pull technology of the BES server and update the SQL database faster.
The flow of the app can be reveiwed before completion.
Using the browser, the driver accepts the order when received, marks picked up, marks delivered, and enters the signing person's name. Everything is time stamped.
The browser is too slow. We need an application written for the Blackberry 7250 (J2ME?) that will utiulize the push/pull technology of the BES server and update the SQL database faster.
The flow of the app can be reveiwed before completion.
