%sql

SELECT c.CompanyName,

s.productline,

SUM(s.revenue) AS revenue

FROM Salesview s

JOIN Company c

ON s.CompanyID = c.CompanyID

WHERE c.CompanyID < 11

GROUP BY c.CompanyName, s.productline

ORDER BY c.CompanyName