INSERT INTO AssistentenTab
  SELECT 3002, 'Platon', 'Ideenlehre', REF(p)
  FROM ProfessorenTab p
  WHERE Name = 'Sokrates';

INSERT INTO AssistentenTab
  SELECT 3003, 'Aristoteles', 'Syllogistik', REF(p)
  FROM ProfessorenTab p
  WHERE Name = 'Sokrates';
  
INSERT INTO AssistentenTab
  SELECT 3004, 'Wittgenstein', 'Sprachtheorie', REF(p)
  FROM ProfessorenTab p
  WHERE Name = 'Russel';

INSERT INTO AssistentenTab
  SELECT 3005, 'Rhetikus', 'Planetenbewegung', REF(p)
  FROM ProfessorenTab p
  WHERE Name = 'Kopernikus';

INSERT INTO AssistentenTab
  SELECT 3006, 'Newton', 'Keplersche Gesetze', REF(p)
  FROM ProfessorenTab p
  WHERE Name = 'Kopernikus';
  
INSERT INTO AssistentenTab
  SELECT 3007, 'Spinoza', 'Gott und Natur', REF(p)
  FROM ProfessorenTab p
  WHERE Name = 'Augustinus';

