SELECT YEAR(t1.date), COUNT(t1.id), COUNT(t2.id) FROM table t1 LEFT JOIN table t2 ON t1.id = t2.id AND t2.cijena1 < t2.cijena2 GROUP BY YEAR(t1.date);