SELECT  NrFaktury,wartosc FROM
(SELECT NrFaktury,SUM(ilosc*cena) AS wartosc FROM szczegoly GROUP BY NrFaktury) sf
WHERE wartosc > (SELECT AVG(suma) FROM (SELECT SUM(ilosc*cena) AS suma from szczegoly GROUP BY NrFaktury)B) --106*

SELECT MONTH(DataFaktury) AS Miesiac,MAX(wartosc) AS MaxWart FROM faktury INNER JOIN (SELECT NrFaktury,SUM(ilosc*cena) AS wartosc FROM szczegoly GROUP BY NrFaktury) sf ON faktury.NrFaktury=sf.NrFaktury GROUP BY MONTH(DataFaktury) ORDER BY Miesiac -- przyklad

SELECT YEAR(DataFaktury) AS rok,AVG(wartosc) AS srednia, MAX(wartosc) AS MaxWart,MIN(wartosc) AS MinWart, STDEVP(wartosc) AS odchylenie FROM faktury
INNER JOIN (SELECT NrFaktury,SUM(ilosc*cena) AS wartosc FROM szczegoly GROUP BY NrFaktury) sf ON faktury.NrFaktury=sf.NrFaktury GROUP BY YEAR(DataFaktury) ORDER BY Rok --107

SELECT YEAR(DataFaktury) AS rok, SUM(ilosc*cena) AS sumai from szczegoly
INNER JOIN faktury ON faktury.NrFaktury=szczegoly.NrFaktury
INNER JOIN klienciind ON klienciind.NIP=faktury.NIP GROUP BY YEAR(DataFaktury)
SELECT YEAR(DataFaktury) AS rok, SUM(ilosc*cena) AS sumai from szczegoly
INNER JOIN faktury ON faktury.NrFaktury=szczegoly.NrFaktury
INNER JOIN instytucje ON instytucje.NIP=faktury.NIP GROUP BY YEAR(DataFaktury)
SELECT YEAR(DataFaktury) AS rok, SUM(ilosc*cena) AS sumaw from szczegoly
INNER JOIN faktury ON faktury.NrFaktury=szczegoly.NrFaktury
 GROUP BY YEAR(DataFaktury)
 SELECT
 indywidualni.rok,sumai,sumain,sumaw,sumai/sumaw AS ProcIND,sumain/sumaw AS ProcentInst
 FROM SELECT YEAR(DataFaktury) AS rok, SUM(ilosc*cena) AS sumai from szczegoly
INNER JOIN faktury ON faktury.NrFaktury=szczegoly.NrFaktury
INNER JOIN klienciind ON klienciind.NIP=faktury.NIP GROUP BY YEAR(DataFaktury)
 --108