SQL-Prüfungsnoten

DROP TABLE IF EXISTS Schueler; CREATE TABLE Schueler ( Name varchar(20), Vorname varchar(20) , Wohnort varchar(15) , PLZ varchar(5) , Telefon varchar(11) , Straße varchar(25) , Schuelernr varchar(7) , PRIMARY KEY (Schuelernr) ); INSERT INTO Schueler VALUES ('Scheurich', 'Erich', 'Bautzen', '02625', '40256', 'Mättigstr. 12', '1234567'); INSERT INTO Schueler VALUES ('Schlenkrich', 'Ricarda', 'Teichritz', '02689', '23456', 'Dorfstr. 2', '1234568'); INSERT INTO Schueler VALUES ('Angst', 'Beatrice', 'Wurschen', '02645', '67255', 'Nr. 12a', '1234569'); INSERT INTO Schueler VALUES ('Waurick', 'Andre', 'Bautzen', '02625', '30445', 'Brecht-Str. 34', '1234572'); INSERT INTO Schueler VALUES ('Scheurich', 'Erick', 'Bautzen', '02625', '40256', 'Mättigstr. 12', '1234573'); DROP TABLE IF EXISTS Noten; CREATE TABLE Noten ( Schuelernr varchar(7), Mathe integer default '0', Deutsch integer, Bio integer ); INSERT INTO Noten VALUES ('1234567', 2, 3, 1); INSERT INTO Noten VALUES ('1234568', 2, 2, 2); INSERT INTO Noten VALUES ('1234569', 3, 4, 2); INSERT INTO Noten VALUES ('1234572', 4, 3, 3); INSERT INTO Noten VALUES ('1234573', 1, 1, 1);