create table student ( name char(20) , vorname char(10), matr_nr integer, fach char(10), semester smallint ); insert into student values ( 'Controlletti', 'Johnny', 100001, 'Physik',6 ); insert into student values ( 'Doria', 'Andrea', 100002, 'BWL', 10 ); insert into student values ( 'Ratlos', 'Rudi', 100003, 'Chemie', 21 ); insert into student values ( 'Mueller', 'Lieschen', 100004, 'Biologie', 23 ); insert into student values ( 'Mueller', 'Sabine', 100005, 'Physik', 8 ); select * from student ; update student set fach='BWL' where name='Mueller' ; delete from student where semester > 20 ;