14_yl
)
AND
b.naised >= (
SELECT
MAX(a.naised)
FROM
(
SELECT
round(avg(emakeel),0) AS naised,
TO_CHAR(TO_DATE(SUBSTR(isikukood,2,2),'RR'),'rrrr') AS naised_aasta
FROM
scott.kandidaadid
WHERE
isikukood LIKE '4%'
GROUP BY
substr (isikukood,2,2)) a
);
6...............................................................................
...........
select
o.nimetus Kursus,
substr
(y.eesnimi ||' '|| y.perenimi,1,15) Nimi,
makskurs.maksimum "Keskmiselt punkte"
from
(select max(keskmised.keskmine) AS maksimum,
keskmised.kursusekood
from
(SELECT AVG(punktid) AS keskmine,
yliopilase_id as id,
kursusekood
FROM
lepikult.koduylesanded
GROUP BY
yliopilase_id,kursusekood) keskmised
GROUP BY
keskmised.kursusekood) makskurs,
(SELECT
AVG(punktid) as keskmine,
yliopilase_id as id,
kursusekood
FROM
lepikult.koduylesanded
GROUP BY
annaabi.ee 
