(zamena izraza)!
@IDSko bigint,
@IDSkoGod int,
@IDUce bigint
AS
SELECT dbo.tPodUce.Prezime, dbo.tPodUce.Ime,(dbo.tOCENE.Ocena)as Prosek,
case LEFT(AVG(dbo.tOCENE.Ocena), 4)
when >=4.50 then 'Odlican'
when >=3.50 and <4.50 then 'Vrlo dobar'
when >=2.50 and <3.50 then 'Dobar'
when >=1.50 and <2.50 then 'Dovoljan'
when <1.50 then 'Nedovoljan'
end
, dbo.tOCENE.ID_Ucenik, dbo.tPodUce.ID_Ucenik AS Expr1,
dbo.tOCENE.ID_SkoGod, dbo.tOCENE.ID_Skola, dbo.tOblastFV.Naziv, dbo.tOblastFV.ID_OblastFV, dbo.tOCENE.ID_OblastFV AS Expr2
FROM dbo.tOCENE INNER JOIN
dbo.tPodUce ON dbo.tOCENE.ID_Ucenik = dbo.tPodUce.ID_Ucenik INNER JOIN
dbo.tOblastFV ON dbo.tOCENE.ID_OblastFV = dbo.tOblastFV.ID_OblastFV
GROUP BY dbo.tOCENE.ID_Skola, dbo.tOCENE.ID_SkoGod, dbo.tPodUce.ID_Ucenik, dbo.tOCENE.ID_Ucenik, dbo.tPodUce.Prezime, dbo.tPodUce.Ime,
dbo.tOblastFV.Naziv, dbo.tOblastFV.ID_OblastFV, dbo.tOCENE.ID_OblastFV
HAVING (dbo.tPodUce.ID_Ucenik = @IDUce) AND (dbo.tOCENE.ID_SkoGod = @IDSkoGod) AND (dbo.tOCENE.ID_Skola = @IDSko)