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.
Latihan ini adalah bagian dari kursus
Intermediate SQL Server
Petunjuk latihan
Create a query that returns the number of rows for each type of MixDesc.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Count the number of rows by MixDesc
SELECT MixDesc, ___
FROM Shipments
GROUP BY ___