Andmebaasid
id = partii.valge and
valge_tulemus = 2
and datediff(mi,algushetk,lopphetk) between 9 and 11;
create view v_7(perenimi) as
select perenimi from isik group by perenimi having count(*)>1;
create view v_8(nimi) as
select nimi from isik, klubi join isik on isik.klubi = klubi.id group by nimi
having count(*)<4;
alter view v_9(Arvo_Valgena) as
select count(*) as Arvod_valgena from Partii,
Isik where Isik.id = Partii.Valge and isik.eesnimi = 'Arvo';
create view v_10(Turniirinimi, Arvo_valgena) as
select Turniir.nimi , count(*) as
Arvod_valgena_turniiridel from Partii, Isik, Turniir where
Isik.id = Partii.Valge and isik.eesnimi =
'Arvo' and Partii.Turniir = Turniir.id group by nimi;
create view v_11(Maria_punktid) as
select sum(Musta_tulemus)/2 as
Maria_punktid from partii, isik
where isik.id = partii.must and
isik.eesnimi = 'Maria'
create view v_12(Turniirinimi, kestvus) AS
select turniir.nimi as
Turniiri_nimi, avg(datediff(mi, algushetk, lopphetk))
annaabi.ee 
