Show Bid Request
Homework Help
Bid Request Id: 34849
|
|
|
|
Posted by: |
dap244 (1 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
|
Posted: |
Nov 10, 2002
7:26:21 PM EDT
|
|
Bidding Closes: |
Nov 12, 2002
8:56:11 PM EDT
|
|
Viewed (by coders): |
72 times
|
|
Deadline: |
11/13/2002
TIME EXPIRED
|
|
|
|
|
Description:
5 sql questions need to be answered and explained. The following questions pertain to the ER Diagram attached.
What is the SQL for the following request?
1. The name of all actors starring in comedy movies that made less than 16 million dollars domestically. Return the actors&' names in one column with the appropriate header, the movie&'s name and the domestic gross of each. Order the results by domestic gross from lowest earner (ie., lowest earner first).
2.The name of all movies in which the director and composer were both born in Belgium or the director and composer were both born in Australia. Return only the movie names in alphabetical order.
3.The names of all actors starring in movies that composer number 18 scored. Return the actors&' names in one column with the appropriate header, the movie&'s name and the release date. Order the results by domestic gross from top earner (ie., top earner first). DO NOT include the composer&'s name or number in the results.
4.The names and genres of all movies scored by a composer who was born and died in the same place and had no movies that made more than 86 million dollars domestically. Return the movie names and genres only. Order by domestic gross from top earner (ie., top earner first).
5.The total amount of money earned by films directed by director number 91 and starring actor number 22. Return only the amount of money with the appropriate header.
Deliverables:
1) The 5 sql questions need to be answered and then explained fully. A step-by-step tutorial of how to solve (answer) the question is required. I fell behind in class and haven't gotten the material yet.
2) Complete ownership and distribution copyrights to all work purchased.
Platform:
mysql version: 3.22.32
Must be 100% finished and received by buyer on:
Nov 13, 2002 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$30 (USD)
|
Nov 10, 2002
9:41:45 PM EDT
|
10
(Excellent)
|
|
|
Hi dap244,
You should do fewer parties or whatever! Just kidding ha ha ha... I'll do your SQL. I can start on it right now if you like and have it for you in the morning so you could have time to look over it!
Visual
Your programming needs are my first priority. Thank you for your consideration! |
|
|
|
|
|
|
