Counting the number of rows
In this exercise, you will calculate the number of orders for each concrete type. Since each row represents one order, all you need to is count the number of rows for each type of MixDesc.
This exercise is part of the course
Intermediate SQL Server
Exercise instructions
Create a query that returns the number of rows for each type of MixDesc.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Count the number of rows by MixDesc
SELECT MixDesc, ___
FROM Shipments
GROUP BY ___