1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate SQL Server

Exercise

Calculating the total

In this chapter, you will use the shipments data. The Shipments table has several columns such as:

  • MixDesc: the concrete type
  • Quantity: the amount of concrete shipped

In this exercise, your objective is to calculate the total quantity for each type of concrete used.

Instructions

100 XP

Write a T-SQL query which will return the sum of the Quantity column as Total for each type of MixDesc.