1,
select count(*) elso_valasz from
(select nev, count(allat) kutyak_szama from tabla where allat = 'kutya' group by nev) kutyak join
(select nev, count(allat) allatok_szama from tabla group by nev) allatok on kutyak.nev = allatok.nev
where allatok_szama = kutyak_szama
2,
select count(*) masodik_valasz from
(select nev, count(allat) kutyak_szama from tabla where allat = 'cica' group by nev) kutyak join
(select nev, count(allat) allatok_szama from tabla group by nev) allatok on kutyak.nev = allatok.nev
where allatok_szama = kutyak_szama
3,
select count(*) harmadik_valasz from
(select nev, count(allat) kutyak_szama from tabla where allat = 'papagáj' group by nev) kutyak join
(select nev, count(allat) allatok_szama from tabla group by nev) allatok on kutyak.nev = allatok.nev
where allatok_szama = kutyak_szama
4, select count(*) negyedik_valasz from (select distinct nev from tabla where nev in (select nev from tabla where allat = 'cica') and allat = 'kutya')
5, select count(*) otodik_valasz from (select distinct nev from tabla where nev in (select nev from tabla where allat = 'cica') and allat = 'papagáj')
6, select count(*) hatodik_valasz from (select distinct nev from tabla where nev in (select nev from tabla where allat = 'kutya') and allat = 'papagáj')
7, select count(*) from (select distinct nev from tabla where nev in (select nev from tabla where nev in (select nev from tabla where allat = 'cica') and allat = 'kutya') and allat = 'papagáj')
höhö, 3 sör után,
ja és sok sikert a tanárodnak.
[ Szerkesztve ]
Thank you to god for making me an atheist