select C.Company_Name, O.Year, O.Order_Type, COUNT(ORDER_ID) from ORDER O INNER JOIN COMPANY C ON O.COMPANY_ID = C.COMPANY_ID GROUP BY O.YEAR, C.COMPANY_NAME, O.ORDER_TYPE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)