История изменений

Исправление ukr_unix_user, 28.12.12 15:20 (текущая версия) :

SELECT 'Gross Sales' AS ' ' , SUM (CASE WHEN period BETWEEN 1 AND 3 THEN sales_amount ELSE 0 END) AS '1st Qtr',
SUM (CASE WHEN period BETWEEN 4 AND 6 THEN sales_amount ELSE 0 END) AS '2nd Qtr',
SUM (CASE WHEN period BETWEEN 7 AND 9 THEN sales_amount ELSE 0 END) AS '3rd Qtr',
SUM (CASE WHEN period BETWEEN 10 AND 12 THEN sales_amount ELSE 0 END) AS '4th Qtr',
SUM(sales_amount) AS 'Totals for 2008' FROM Sales2008

только агрегатную ф-ию поменяй. не?

Исходная версия ukr_unix_user, 28.12.12 15:19:

SELECT 'Gross Sales' AS ' ' , SUM (CASE WHEN period BETWEEN 1 AND 3 THEN sales_amount ELSE 0 END) AS '1st Qtr',
SUM (CASE WHEN period BETWEEN 4 AND 6 THEN sales_amount ELSE 0 END) AS '2nd Qtr',
SUM (CASE WHEN period BETWEEN 7 AND 9 THEN sales_amount ELSE 0 END) AS '3rd Qtr',
SUM (CASE WHEN period BETWEEN 10 AND 12 THEN sales_amount ELSE 0 END) AS '4th Qtr',
SUM(sales_amount) AS 'Totals for 2008' FROM Sales2008

не?