|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Oracle/SQL HELP!!!!!
I need help with basic SQL. I have an assignment I am so lost on. It is basic..here it is...
Homework #5 CSC 449: Database Technologies Page 1 of 2 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. Unless otherwise specified, each problem is worth 5 points. 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? |
|
#2
|
|||
|
|||
|
RE: Oracle/SQL HELP!!!!!
What school is this for? do you have a website for it?
|
|
#3
|
|||
|
|||
|
RE: Oracle/SQL HELP!!!!!
hey, no cheating on your homework!!
Quote:
|
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Oracle/SQL HELP!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|