a)


CREATE VIEW kuseng AS

SELECT 	DISTINCT kind.child AS Kind, vetter.child AS Kuseng
FROM
	windsor.parents AS kind,
 	windsor.parents AS eltern,
	windsor.parents AS geschwister,
	windsor.parents AS vetter,
	windsor.royals

WHERE	(eltern.father = geschwister.father
		AND
	kind.father != vetter.father
		AND
	(kind.father = eltern.child
		OR
	kind.mother = eltern.child)
		AND
	(vetter.father = geschwister.child
		OR
	vetter.mother= geschwister.child)
	)

	AND

	(vetter.child = royals.name
		AND
	royals.sex = 'm'
	)


ORDER BY kind.child




b)

CREATE OR REPLACE VIEW bb AS
 SELECT avg(2011 - royals.born) AS durschnittsalter, count(royals.*) AS anzahl
   FROM windsor.royals
  WHERE royals.died IS NULL;

ALTER TABLE bb OWNER TO haering;