Calculating the total
In this chapter, you will use the shipments data. The Shipments table has several columns such as:
MixDesc: the concrete typeQuantity: the amount of concrete shipped
In this exercise, your objective is to calculate the total quantity for each type of concrete used.
Bu egzersiz
Intermediate SQL Server
kursunun bir parçasıdırEgzersiz talimatları
Write a T-SQL query which will return the sum of the Quantity column as Total for each type of MixDesc.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Write a query that returns an aggregation
___ MixDesc, ___
FROM Shipments
-- Group by the relevant column
___