LISTING 2: Total Quantity by Store ID and Order Year

USE Pubs

SELECT
  stor_id,
  SUM(CASE YEAR(ord_date)
        WHEN 1992 THEN qty
        ELSE 0
      END) AS c1992,
  SUM(CASE YEAR(ord_date)
        WHEN 1993 THEN qty
        ELSE 0
      END) AS c1993,
  SUM(CASE YEAR(ord_date)
        WHEN 1994 THEN qty
        ELSE 0
      END) AS c1994
FROM Sales
GROUP BY stor_id
ORDER BY stor_id