SELECT DISTINCT kind.child AS kind, vetter.child AS kuseng
   FROM windsor.parents kind, windsor.parents eltern, windsor.parents geschwister, windsor.parents vetter, windsor.royals
  WHERE eltern.father::text = geschwister.father::text AND kind.father::text <> vetter.father::text AND (kind.father::text = eltern.child::text OR kind.mother::text = eltern.child::text) AND (vetter.father::text = geschwister.child::text OR vetter.mother::text = geschwister.child::text) AND vetter.child::text = royals.name::text AND royals.sex = 'm'::bpchar
  ORDER BY kind.child;




CREATE VIEW AlterAnzahl AS SELECT AVG(2011-royals.born) AS Durchschnittsalter, count(royals) AS Anzahl
FROM windsor.royals
WHERE royals.died IS NULL