Conteo de registros con 0

[navsdyonel]

Algo mas simple.

Código SQL:

SELECT Colores.COLOR,COUNT(Autos.COLOR) TOTAL FROM Colores
LEFT JOIN Autos  ON Colores.ColorId = Autos.COLORID
GROUP BY Colores.COLOR ORDER BY 2 DESC