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