'receiving error code every time i try execute
Select c.CategoryName,COUNT(p1.ProductID) as CountOfProduct, MAX(p1.ListPrice) as MaxOfProduct
From Categories as c1 JOIN products as p1
ON c1.CategoryID=p1.CategoryID
Group By c1.CategoryName
Order By CountOfProduct DESC
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|