smog
Bekanntes Mitglied
- Dabei seit
- 04.10.2002
- Beiträge
- 116
- Reaktionspunkte
- 0
Ich muss für ein Studienprojekt SQL Queries ausarbeiten und schaffe fünf davon einfach nicht. Ich versuch sie in VS zu schreiben aber bei den fünf beiß ich mir schon seit Tagen die Zähne aus.
Ich hab die Tabellen mit den Argumenten:
STUDENT (sid, sname, sex, age, year, averagegrade)
SCHOOL (dname, numhonours)
PROF (pname, dname)
COURSE (dname, cno, cname)
MAJOR (dname, sid)
CLASS (dname, cno, classno, pname)
ENROLL (sid, dname, cno, classno, grade)
Die fünf Abfragen die ich einfach nicht schaffe:
5. List the professors in which every class they teach has at least one student who is younger
than twenty.
6. Find the names and majors of the students who are taking at least two database related
courses, i.e, courses containing the word "database".
7. List the name of the schools and its number of honours students if the school has no major
containing “database” courses.
8. For each class from the SIT school, display the course number, class number, and the lowest
average grade of the students enrolled in that class. Sort the results in ascending order of lowest average grade.
9. List the student names with the second highest average grade in their major schools.
10. List the student names who are taking courses from either the SIT school or the business school, but not from both.
Vielleicht kann mir jemand helfen, ich bin wirklich schon am verzweifeln und bin auch wirklich kein DB Spezialist, eher ein Noop....
mfg
smog
Ich hab die Tabellen mit den Argumenten:
STUDENT (sid, sname, sex, age, year, averagegrade)
SCHOOL (dname, numhonours)
PROF (pname, dname)
COURSE (dname, cno, cname)
MAJOR (dname, sid)
CLASS (dname, cno, classno, pname)
ENROLL (sid, dname, cno, classno, grade)
Die fünf Abfragen die ich einfach nicht schaffe:
5. List the professors in which every class they teach has at least one student who is younger
than twenty.
6. Find the names and majors of the students who are taking at least two database related
courses, i.e, courses containing the word "database".
7. List the name of the schools and its number of honours students if the school has no major
containing “database” courses.
8. For each class from the SIT school, display the course number, class number, and the lowest
average grade of the students enrolled in that class. Sort the results in ascending order of lowest average grade.
9. List the student names with the second highest average grade in their major schools.
10. List the student names who are taking courses from either the SIT school or the business school, but not from both.
Vielleicht kann mir jemand helfen, ich bin wirklich schon am verzweifeln und bin auch wirklich kein DB Spezialist, eher ein Noop....
mfg
smog
