SELECT modele.nazwa, COUNT(rowery.id)
FROM modele
INNER JOIN rowery
ON rowery.id_modelu = modele.id
GROUP BY modele.id