SELECT o.idomnibus,COUNT(v.idomnibus) AS 'cantidad de viajes' FROM omnibus AS o LEFT JOIN viajes AS v ON v.idomnibus=o.idomnibus GROUP BY o.idomnibus;