'How to merge Car Stock Totals by Colors in MySQL/SQL? [closed]

We have two car shops and each shop has 12 different models of cars. The cars are of different models and colors. There are also a few cars of the same color, of the same model.

That's why I want to count all the cars in both stores according to the number of colors. Ny fiddle is below:

Sample fiddle database is here:

I have query in above link but query only counts CompanyA or CompanyB total. How can I find grand total of cars and color in our stock?

Thanks for you help.

mysqlsqldatabase


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions