picccc

//hlavni dotaz
SELECT DISTINCT z.jmeno,
(((sum_2012.CELKEM_2012+0.0)/(sum_celkem.CELKEM))*100) AS procenta
FROM zakaznik z JOIN koupil k ON z.zID = k.zID

JOIN
(
SELECT z.zID,SUM(k.kusu * k.cena) AS CELKEM FROM zakaznik z
JOIN koupil k ON z.zID = k.zID
GROUP BY z.zID
) sum_celkem ON sum_celkem.zID=k.zID

JOIN
(
SELECT z.zID, SUM(k.kusu * k.cena) AS CELKEM_2012 FROM zakaznik z
LEFT JOIN koupil k ON z.zID = k.zID
JOIN produkt p ON p.pID = k. pID
GROUP BY z.zID, rok_ukonceni_vyroby
HAVING rok_ukonceni_vyroby = (SELECT MAX(rok_ukonceni_vyroby) FROM produkt p)
)sum_2012 ON sum_celkem.zID=sum_2012.zID

WHERE pID IN(
SELECT pID FROM produkt p
WHERE rok_ukonceni_vyroby =(SELECT MAX(rok_ukonceni_vyroby) FROM produkt p)
)



//celkova suma utracena jednotlivym zakaznikem
SELECT z.zID,SUM(k.kusu * k.cena) AS CELKEM FROM zakaznik z
JOIN koupil k ON z.zID = k.zID
GROUP BY z.zID

//celkova suma utracena zakaznikem za vyrobky ktere maji rok vyroby MAX
SELECT z.zID, SUM(k.kusu * k.cena) AS CELKEM_2012 FROM zakaznik z
LEFT JOIN koupil k ON z.zID = k.zID
JOIN produkt p ON p.pID = k. pID
GROUP BY z.zID, rok_ukonceni_vyroby
HAVING rok_ukonceni_vyroby = (SELECT MAX(rok_ukonceni_vyroby) FROM produkt p)