Resultate der Anfragen für das Aufgabenblatt 5
2005-01-10 21:56
Anonymer User
Ich würde hier gerne die Resultate meiner Anfragen für die Aufgaben 2 und 3 des fünften Aufgabenblattes zur Diskussion stellen. Wenn jemand abweichende Ergebnisse hat, so soll er sich gerne melden, und vielleicht gibt es ja den einen oder anderen der sich auch noch wohler fühlt wenn er seine Ergebnisse vergleichen kann.
Aufgabe 2, Namen die mit G beginnen:
Name = Graham
Name = Gonzales
Name = Gafney
Aufgabe 3.1, Name, Beruf, Gehalt… von Angestellten geordnet nach Gehalt:
Firstname = JOHN
Lastname = PARKER
Job = OPERATOR
Department = E11
Salary = 15340.00
nächster
Firstname = MAUDE
Lastname = SETRIGHT
Job = OPERATOR
Department = E11
Salary = 15900.00
nächster
Firstname = SYBIL
Lastname = JOHNSON
Job = CLERK
Department = D21
Salary = 17250.00
nächster
Firstname = PHILIP
Lastname = SMITH
Job = OPERATOR
Department = E11
Salary = 17750.00
nächster
Firstname = WILLIAM
Lastname = JONES
Job = DESIGNER
Department = D11
Salary = 18270.00
nächster
Firstname = DANIEL
Lastname = SMITH
Job = CLERK
Department = D21
Salary = 19180.00
nächster
Firstname = RAMLAL
Lastname = MEHTA
Job = FIELDREP
Department = E21
Salary = 19950.00
nächster
Firstname = JAMES
Lastname = WALKER
Job = DESIGNER
Department = D11
Salary = 20450.00
nächster
Firstname = MARILYN
Lastname = SCOUTTEN
Job = DESIGNER
Department = D11
Salary = 21340.00
nächster
Firstname = JAMES
Lastname = JEFFERSON
Job = CLERK
Department = D21
Salary = 22180.00
nächster
Firstname = ELIZABETH
Lastname = PIANKA
Job = DESIGNER
Department = D11
Salary = 22250.00
nächster
Firstname = DOLORES
Lastname = QUINTANA
Job = ANALYST
Department = C01
Salary = 23800.00
nächster
Firstname = JASON
Lastname = GOUNOT
Job = FIELDREP
Department = E21
Salary = 23840.00
nächster
Firstname = MASATOSHI
Lastname = YOSHIMURA
Job = DESIGNER
Department = D11
Salary = 24680.00
nächster
Firstname = BRUCE
Lastname = ADAMSON
Job = DESIGNER
Department = D11
Salary = 25280.00
nächster
Firstname = WING
Lastname = LEE
Job = FIELDREP
Department = E21
Salary = 25370.00
nächster
Firstname = THEODORE
Lastname = SPENSER
Job = MANAGER
Department = E21
Salary = 26150.00
nächster
Firstname = ETHEL
Lastname = SCHNEIDER
Job = OPERATOR
Department = E11
Salary = 26250.00
nächster
Firstname = MARIA
Lastname = PEREZ
Job = CLERK
Department = D21
Salary = 27380.00
nächster
Firstname = DAVID
Lastname = BROWN
Job = DESIGNER
Department = D11
Salary = 27740.00
nächster
Firstname = HEATHER
Lastname = NICHOLLS
Job = ANALYST
Department = C01
Salary = 28420.00
nächster
Firstname = SALVATORE
Lastname = MARINO
Job = CLERK
Department = D21
Salary = 28760.00
nächster
Firstname = SEAN
Lastname = O'CONNELL
Job = CLERK
Department = A00
Salary = 29250.00
nächster
Firstname = EILEEN
Lastname = HENDERSON
Job = MANAGER
Department = E11
Salary = 29750.00
nächster
Firstname = JENNIFER
Lastname = LUTZ
Job = DESIGNER
Department = D11
Salary = 29840.00
nächster
Firstname = IRVING
Lastname = STERN
Job = MANAGER
Department = D11
Salary = 32250.00
nächster
Firstname = EVA
Lastname = PULASKI
Job = MANAGER
Department = D21
Salary = 36170.00
nächster
Firstname = SALLY
Lastname = KWAN
Job = MANAGER
Department = C01
Salary = 38250.00
nächster
Firstname = JOHN
Lastname = GEYER
Job = MANAGER
Department = E01
Salary = 40175.00
nächster
Firstname = MICHAEL
Lastname = THOMPSON
Job = MANAGER
Department = B01
Salary = 41250.00
nächster
Firstname = VINCENZO
Lastname = LUCCHESSI
Job = SALESREP
Department = A00
Salary = 46500.00
nächster
Firstname = CHRISTINE
Lastname = HAAS
Job = PRES
Department = A00
Salary = 52750.00
Aufgabe 3.2, Durchschnittsgehälter in den Abteilungen:
Department: A00
Durchschnitt = 42833.333333333333333333333333
Department: B01
Durchschnitt = 41250.000000000000000000000000
Department: C01
Durchschnitt = 30156.666666666666666666666666
Department: D11
Durchschnitt = 24677.777777777777777777777777
Department: D21
Durchschnitt = 25153.333333333333333333333333
Department: E01
Durchschnitt = 40175.000000000000000000000000
Department: E11
Durchschnitt = 20998.000000000000000000000000
Department: E21
Durchschnitt = 23827.500000000000000000000000
Aufgabe 3.3, Durchschnittsgehälter in Abteilungen wo größer als 30000:
A00
Durchschnitt = 42833.333333333333333333333333
B01
Durchschnitt = 41250.000000000000000000000000
C01
Durchschnitt = 30156.666666666666666666666666
E01
Durchschnitt = 40175.000000000000000000000000
Aufgabe 3.4, volles Gehalt des Mangers der Abteilung Information Center:
39050.00
Aufgabe 3.5, Abteilungen mit Bonus größer als 500:
Department = ADMINISTRATION SYSTEMS
Department = INFORMATION CENTER
Department = MANUFACTURING SYSTEMS
Department = OPERATIONS
Department = PLANNING
Department = SPIFFY COMPUTER SERVICE DIV.
Department = SUPPORT SERVICES
Aufgabe 3.6, Projekte in denen der Manager der Abteilung Spiffy… arbeitet:
ADMIN SERVICES, W L PROGRAMMING, WELD LINE AUTOMATION
Aufgabe 2, Namen die mit G beginnen:
Name = Graham
Name = Gonzales
Name = Gafney
Aufgabe 3.1, Name, Beruf, Gehalt… von Angestellten geordnet nach Gehalt:
Firstname = JOHN
Lastname = PARKER
Job = OPERATOR
Department = E11
Salary = 15340.00
nächster
Firstname = MAUDE
Lastname = SETRIGHT
Job = OPERATOR
Department = E11
Salary = 15900.00
nächster
Firstname = SYBIL
Lastname = JOHNSON
Job = CLERK
Department = D21
Salary = 17250.00
nächster
Firstname = PHILIP
Lastname = SMITH
Job = OPERATOR
Department = E11
Salary = 17750.00
nächster
Firstname = WILLIAM
Lastname = JONES
Job = DESIGNER
Department = D11
Salary = 18270.00
nächster
Firstname = DANIEL
Lastname = SMITH
Job = CLERK
Department = D21
Salary = 19180.00
nächster
Firstname = RAMLAL
Lastname = MEHTA
Job = FIELDREP
Department = E21
Salary = 19950.00
nächster
Firstname = JAMES
Lastname = WALKER
Job = DESIGNER
Department = D11
Salary = 20450.00
nächster
Firstname = MARILYN
Lastname = SCOUTTEN
Job = DESIGNER
Department = D11
Salary = 21340.00
nächster
Firstname = JAMES
Lastname = JEFFERSON
Job = CLERK
Department = D21
Salary = 22180.00
nächster
Firstname = ELIZABETH
Lastname = PIANKA
Job = DESIGNER
Department = D11
Salary = 22250.00
nächster
Firstname = DOLORES
Lastname = QUINTANA
Job = ANALYST
Department = C01
Salary = 23800.00
nächster
Firstname = JASON
Lastname = GOUNOT
Job = FIELDREP
Department = E21
Salary = 23840.00
nächster
Firstname = MASATOSHI
Lastname = YOSHIMURA
Job = DESIGNER
Department = D11
Salary = 24680.00
nächster
Firstname = BRUCE
Lastname = ADAMSON
Job = DESIGNER
Department = D11
Salary = 25280.00
nächster
Firstname = WING
Lastname = LEE
Job = FIELDREP
Department = E21
Salary = 25370.00
nächster
Firstname = THEODORE
Lastname = SPENSER
Job = MANAGER
Department = E21
Salary = 26150.00
nächster
Firstname = ETHEL
Lastname = SCHNEIDER
Job = OPERATOR
Department = E11
Salary = 26250.00
nächster
Firstname = MARIA
Lastname = PEREZ
Job = CLERK
Department = D21
Salary = 27380.00
nächster
Firstname = DAVID
Lastname = BROWN
Job = DESIGNER
Department = D11
Salary = 27740.00
nächster
Firstname = HEATHER
Lastname = NICHOLLS
Job = ANALYST
Department = C01
Salary = 28420.00
nächster
Firstname = SALVATORE
Lastname = MARINO
Job = CLERK
Department = D21
Salary = 28760.00
nächster
Firstname = SEAN
Lastname = O'CONNELL
Job = CLERK
Department = A00
Salary = 29250.00
nächster
Firstname = EILEEN
Lastname = HENDERSON
Job = MANAGER
Department = E11
Salary = 29750.00
nächster
Firstname = JENNIFER
Lastname = LUTZ
Job = DESIGNER
Department = D11
Salary = 29840.00
nächster
Firstname = IRVING
Lastname = STERN
Job = MANAGER
Department = D11
Salary = 32250.00
nächster
Firstname = EVA
Lastname = PULASKI
Job = MANAGER
Department = D21
Salary = 36170.00
nächster
Firstname = SALLY
Lastname = KWAN
Job = MANAGER
Department = C01
Salary = 38250.00
nächster
Firstname = JOHN
Lastname = GEYER
Job = MANAGER
Department = E01
Salary = 40175.00
nächster
Firstname = MICHAEL
Lastname = THOMPSON
Job = MANAGER
Department = B01
Salary = 41250.00
nächster
Firstname = VINCENZO
Lastname = LUCCHESSI
Job = SALESREP
Department = A00
Salary = 46500.00
nächster
Firstname = CHRISTINE
Lastname = HAAS
Job = PRES
Department = A00
Salary = 52750.00
Aufgabe 3.2, Durchschnittsgehälter in den Abteilungen:
Department: A00
Durchschnitt = 42833.333333333333333333333333
Department: B01
Durchschnitt = 41250.000000000000000000000000
Department: C01
Durchschnitt = 30156.666666666666666666666666
Department: D11
Durchschnitt = 24677.777777777777777777777777
Department: D21
Durchschnitt = 25153.333333333333333333333333
Department: E01
Durchschnitt = 40175.000000000000000000000000
Department: E11
Durchschnitt = 20998.000000000000000000000000
Department: E21
Durchschnitt = 23827.500000000000000000000000
Aufgabe 3.3, Durchschnittsgehälter in Abteilungen wo größer als 30000:
A00
Durchschnitt = 42833.333333333333333333333333
B01
Durchschnitt = 41250.000000000000000000000000
C01
Durchschnitt = 30156.666666666666666666666666
E01
Durchschnitt = 40175.000000000000000000000000
Aufgabe 3.4, volles Gehalt des Mangers der Abteilung Information Center:
39050.00
Aufgabe 3.5, Abteilungen mit Bonus größer als 500:
Department = ADMINISTRATION SYSTEMS
Department = INFORMATION CENTER
Department = MANUFACTURING SYSTEMS
Department = OPERATIONS
Department = PLANNING
Department = SPIFFY COMPUTER SERVICE DIV.
Department = SUPPORT SERVICES
Aufgabe 3.6, Projekte in denen der Manager der Abteilung Spiffy… arbeitet:
ADMIN SERVICES, W L PROGRAMMING, WELD LINE AUTOMATION