/* 1 */
select sum(Placa) as ZbrojPlaca from Predavac;
/* 2 */
select avg(Placa) as ProsjecnaPlaca from Predavac;
/* 3 */
select count(StudentID) as StudentiPrvasi from Student
where GodinaStudija=1;
/* 4 */
select count(StudentID) as BrojStudenata from Student;
/* 5 */
select GodinaStudija, count(StudentID) as BrojStudenata from Student
group by GodinaStudija;
/* 6 */
select BrojSobe, min(Placa) as MinPlacaPoSobi from Predavac
group by BrojSobe;
/* 7 */
select BrojSobe, max(Placa) as MaxPlacaPoSobi from Predavac
group by BrojSobe;
/* 8 */
select min(Placa) as MinSoba203 from Predavac
where BrojSobe=203;
/* 9 */
select BrojSobe, avg(Placa) as ProsjecnaPlaca from Predavac
group by BrojSobe
having count(PredavacID) > 1;
/* 10 */
select BrojSobe, sum(Placa) as ZbrojPlacaPoSobi from Predavac
group by BrojSobe;
/* 11 */
update Predavac
set Placa=Placa*1.025;
select * from Predavac;
/* 12 */
insert into Student (StudentID, ImeS, PrezimeS, DatumRodjenja, GodinaStudija)
values
(21,’Mirko’,’Mirković’,’2002-1-5′,1);
select * from Student;
/* 13 */
delete Student
where StudentID=21;
select * from Student;
/* 14 */
select Student.ImeS, Student.PrezimeS, Student.GodinaStudija, Kolegij.ImeK, Polaznik.Ocjena, Predavac.PrezimeP from Student
inner join Polaznik on Student.StudentID = Polaznik.StudentID
inner join Kolegij on Polaznik.KolegijID = Kolegij.KolegijID
inner join Predavac on Kolegij.PredavacID = Predavac.PredavacID
order by Student.GodinaStudija asc, Kolegij.ImeK asc;
/* 15 */
select Student.GodinaStudija, avg(Polaznik.Ocjena * 1.0) as ProsjecnaOcjena from Student
inner join Polaznik on Student.StudentID = Polaznik.StudentID
group by Student.GodinaStudija;