· SUM SELECT Sum(Filmy.[F_dlzka]) AS [Celková dlžka filmov]
FROM Filmy;
· LAST SELECT Filmy.[F_nazov_sk] AS Film, Filmy.[F_rok] AS Rok, Filmy.[F_zaner] AS Žáner
FROM Filmy
WHERE (Filmy.F_nazov_sk)=(SELECT last (Filmy.[F_nazov_sk]) From Filmy);
· MAX SELECT Filmy.[F_dlzka] AS Dížka, Filmy.[F_nazov_sk] AS Film
FROM Filmy
WHERE (Filmy.F_dlzka)=(SELECT MAX (Filmy.[F_dlzka]) from Filmy);
· MIN SELECT Filmy.[F_dlzka] AS Dížka, Filmy.[F_nazov_sk] AS Film
FROM Filmy
WHERE (Filmy.F_dlzka)=(SELECT MIN (Filmy.[F_dlzka]) from Filmy);
· COUNT SELECT Count (Filmy.[F_ID]) AS Počet
FROM Filmy;
· LAST SELECT Filmy.[F_nazov_sk], Filmy.[F_rok], Filmy.[F_zaner]
FROM Filmy;
· AVG SELECT AVG (Filmy.[F_dlzka]) AS [Priemerná dížka filmov]
FROM Filmy;