StRiPy:
Ako se radi o MySQL bazi (verzija min. 4.1), onda bi se moglo uraditi pomocu podupita (subqueries):
Code:
SELECT t1.Ime, t2.num AS Uplaceno, t3.num2 AS Uplatnica, (t2.num/t3.num2)*100 AS '%' FROM
uplate AS t1,
(SELECT Ime, COUNT(*) AS num
FROM uplate
WHERE uplatio=TRUE
GROUP BY Ime
) AS t2,
(SELECT Ime, COUNT(*) AS num2
FROM uplate
GROUP BY Ime
) AS t3
WHERE t1.Ime=t2.Ime AND t1.Ime = t3.Ime
GROUP BY t1.Ime;
Je li to rjesenje koje ti treba? Ako nije, trazicemo drugo kad se naspavam :)