Zad4

USE ABDUczelnia;

WITH IloscOcen AS
(
    SELECT 1 AS IleOcen
    UNION ALL
    SELECT IleOcen + 1
    FROM IloscOcen
    WHERE IleOcen +1 <=20


)

SELECT COUNT(O.Ocena) AS IluStudentow
FROM Oceny AS O
WHERE O.Ocena<4 AND O.DataOceny BETWEEN '2013-01-01' AND '2013-12-31'
GROUP BY O.IdStudenta
ORDER BY IluStudentow DESC