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