Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
SELECT T2.Country, T1.FuelType, ISNULL(COUNT(*), 0) AS total FROM tblCars AS T3 INNER JOIN tblCountry AS T2 ON T3.CountryID = T2.CountryID RIGHT OUTER JOIN tblFuelType AS T1 ON T3.FuelTypeID = T1.FuelTypeID WHERE T1.FuelTypeID IN (2, 3, 4) GROUP BY T1.FuelTypeID, T2.Country ORDER BY T2.Country, T1.FuelTypeID
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!