Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment