How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
(See all)
Chatroom Needed Immediately
By blaster998 on Sep 30
Max Bid: $500


Fix link tracking program
By blaster998 on Sep 30
Max Bid: $75


Install TOMCAT on FreeBSD(repost)
By Kevbob on Sep 30
Max Bid: $100


Stormpay IPN Urgent Help Needed
By rohit123 on Sep 29
Max Bid: Open to fair suggestions


Spyware Application/ Spyware Scanner
By GuyB on Sep 29
Max Bid: $500


Web module in PHP/MySQL
By RXL on Sep 29
Max Bid: Open to fair suggestions


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(175 open)
   Access 
(53 open)
   MySQL 
(113 open)
   Oracle 
(11 open)
   SQL Server 
(72 open)
   Other DB 
(28 open)
Documentation / Tech Writing 
(26 open)
   Language (Human) Translations 
(10 open)
Data Entry 
(37 open)
Game Development 
(26 open)
Graphics / Art / Music 
(60 open)
   Graphics 
(64 open)
     Adobe AfterEffects 
(7 open)
     Adobe Photoshop 
(32 open)
     Adobe Premiere 
(6 open)
     3d Animation 
(21 open)
   Art (Misc.) 
(13 open)
   Music 
(7 open)
   Photography 
(5 open)
   3d Modeling 
(15 open)
Language Specific 
(121 open)
   Assembly / Machine language 
(15 open)
   ASP 
(65 open)
   ASP .NET 
(72 open)
   C# 
(75 open)
   C++ / C 
(162 open)
   Carbon (Mac OS) 
(5 open)
   Cocoa / Obj-C 
(5 open)
   Cold Fusion 
(11 open)
   Delphi 
(56 open)
   Java 
(102 open)
   JSP 
(21 open)
   Perl 
(47 open)
   Python 
(6 open)
   PHP 
(117 open)
   XML/XSL 
(33 open)
   Visual Basic 
(161 open)
   Visual Basic .Net 
(108 open)
   Other 
(78 open)
Misc 
(48 open)
   Middleware 
(3 open)
   CAD 
(3 open)
MultiMedia 
(28 open)
   Video Editing 
(5 open)
Network 
(34 open)
   Network Design 
(8 open)
   Network Implementation 
(7 open)
Platforms 
(80 open)
   Windows 
(195 open)
     MS Exchange 
(9 open)
     MS Office 
(28 open)
     Other 
(15 open)
   Darwin 
(1 open)
   Embedded Systems 
(16 open)
   Hand Held/PDA Programming 
(21 open)
   Internet Browser 
(47 open)
   Linux 
(63 open)
   Lotus Notes / Domino 
(3 open)
   UNIX 
(33 open)
Requirements 
(16 open)
Security 
(34 open)
Testing / Quality Assurance 
(22 open)
Web 
(171 open)
   Page Design 
(92 open)
   Flash 
(54 open)
   Marketing 
(15 open)
     Search Engine Optimization 
(12 open)
     Marketing (Other) 
(10 open)
   Web Services 
(91 open)
   Web (Other) 
(104 open)
Training 
(16 open)
   Computer Based 
(14 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

Easy SQL help
Bid Request Id: 33941
Bookmark in my 'To Do' list
Posted by: kev6873 (1 ratings)
(Software buyer rating 10)
Non-action Ratio: Above Average - 33.33%
Buyer Security Verifications: Good
Approved on: Nov 4, 2002
4:46:11 PM EDT
Bidding Closes: Nov 5, 2002
6:35:18 PM EDT
Viewed (by coders): 108 times
Deadline: 11/5/2002 6:30:00 PM
TIME EXPIRED
Phase:
Cancelled
Max Accepted Bid: Bidding is closed
Project Type: Personal Project / Homework Help
Bidding Type: Open Auction
Categories: Database, Language Specific, Other
Enter chat room for this bid request
(0 active users at Sep 30, 2003 6:47:51 AM EDT)

Description:
I need this done before 530PM today Nov. 4, if at all possible. I cant hand in late. I have 2 problems...Here is first one. PLease email me at kevin.sawyers at abbott.com if you can do this. I will pay right away and also send the data files that are needed. Thanks a ton!!!!


Answer the following questions using the School database and the data provided. For each question,
submit the SQL statements used to determine the answer and your answer.

I just need you to write the SQL statements as you would using an ORACLE DB. The tables are


1) What is the numerical grade point average for each student listed in the database, in alphabetical
order?
2) How many students are majoring in each department?
3) Provide a list of the students by age, oldest first.
4) Which students have a grade point average that is higher than the grade point average of students
who are majoring in ECT?
5) Which students have a grade point average that is higher than the grade point average of all the
students who are majoring in HCI?
6) Provide a list of the different instructors that are teaching in the current academic year.
7) Which students have taken courses taught by Xiaoping Xia?
8) Which students have taken a course that is among the courses taught by Xiaoping Xia, even if
the student did not take the course from Xiaoping Xia?
9) Which instructors teach courses in the same department as those taught by Evelyn Lulis and
Yoseph Winograd?
10) Which five students have the highest grade point averages?


Second problem

Develop and populate a database that represents the ER Diagram for problem 3.16. Populate this database with representative data. Submit the structure of your database (use the DESCRIBE table command in Oracle) and the contents of all the tables using SELECT statements.

I think these are both fairy easy for SQL folks who know what the heck is going on.. Please help

kevin

Deliverables:


Just the SQL statements are fine....thanks.....



Platform:
win2000, oracle, sql

Must be 100% finished and received by buyer on:
Nov 5, 2002 6:30:00 PM 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.

Special Conditions / Other:
I can have your money to you ASP using any form necessary. Please help....must be done tonite before 545PM central time


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  


No bidding allowed, because this bid request was cancelled.

Cancelled Date: 11/8/2002 11:13:00 AM
Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Securenext
Rated a 9.96 on 127 jobs 
Buddies
Rated a 9.86 on 97 jobs 
Codman
Rated a 9.97 on 159 jobs 
hernest
Rated a 10 on 122 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
D-N-S
Rated a 9.93 on 40 jobs 
markesh
Rated a 10 on 24 jobs 
GribFritz
Rated a 9.89 on 158 jobs 
PSergei
Rated a 9.78 on 112 jobs 
ASP.NET
Rated a 9.86 on 62 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.