utery_variantaB_2

SELECT o.uID, o.jmeno, ob.oID, COUNT(*) pocetPolozek
FROM osoba o
LEFT JOIN objednavka ob ON ob.uID = o.uID
JOIN polozka p ON p.oID = ob.oID
WHERE NOT EXISTS
(
    SELECT *
    FROM objednavka ob2
    WHERE ob2.uID = o.uID AND
          ob2.oID <> ob.oID AND
          ob2.vytvorena < ob.vytvorena
)
GROUP BY o.uID, o.jmeno, ob.oID