Baze podataka 3

Neki od upita koji su rađeni u učionici (prvi čas vežbi) :

use IzlozbaPasa

select *
from Pas;

select Ime
from Pas;

select Ime
from Pas
order by Ime desc;

select Ime from Pas
where Ime Like 'A%';

select COUNT(*) from Pas
where Ime Like 'A%';

select COUNT(PasID)
from Pas
group by RasaID;

select COUNT(Ostenjen)
from Pas;

select COUNT(distinct Ime)
from Pas;

select distinct(RasaID)
from Pas;

select COUNT( Ime), RasaID
from Pas
group by RasaID
having COUNT(Ime) >=15;

select COUNT(Ime), PolID
from Pas
group by PolID;

select MAX(Tezina)
from Pas;

select COUNT(PasID)
from Pas
where Tezina > 15;

  *******************************

select Pas.Ime, Rasa.NazivRase
from Pas, Rasa;

select Pas.Ime, Rasa.NazivRase
from Pas, Rasa
where Pas.RasaID = Rasa.RasaID;

select Pas.Ime, Duzina_Dlake.Duzina, Rasa.NazivRase
from Pas, Duzina_Dlake, Rasa
where (Pas.DDID = Duzina_Dlake.DDID) and (Pas.RasaID = Rasa.RasaID);

select P.Ime 
from Pas P;

select Rasa.NazivRase
from Rasa;

select *
from Izlozba;

select * 
from Rezultat;

select P.Ime
from Pas P, Rezultat R
where R.Rezultat is null AND P.PasID = R.PasID;