SELECT kebulu_tipai.name,ROUND(AVG(automobiliai.verte),0) as verte
FROM `automobiliai`,`kebulu_tipai`
WHERE YEAR(automobiliai.registravimo_data)=2014
AND kebulu_tipai.id = automobiliai.kebulas
GROUP BY automobiliai.kebulas ORDER BY erte DESC