CREATE OR REPLACE VIEW sales_across_quarter AS

SELECT year, region, q1, q2, q3, q4

FROM sales

TRANSFORM (sum(sales) AS sales

FOR quarter

IN (1 AS q1, 2 AS q2, 3 AS q3, 4 AS q4));

CREATE OR REPLACE VIEW sales_across_quarter AS

SELECT year, region, q1, q2, q3, q4

FROM sales

PIVOT (sum(sales) AS sales

FOR quarter

IN (1 AS q1, 2 AS q2, 3 AS q3, 4 AS q4));

CREATE OR REPLACE VIEW sales_across_quarter AS

SELECT year, region, q1, q2, q3, q4

FROM sales

REDUCE (sum(sales) AS sales

FOR quarter

IN (1 AS q1, 2 AS q2, 3 AS q3, 4 AS q4));

CREATE OR REPLACE VIEW sales_across_quarter AS

SELECT year, region, q1, q2, q3, q4

FROM sales

EXIST(sum(sales) AS sales

FOR quarter

IN (1 AS q1, 2 AS q2, 3 AS q3, 4 AS q4));

CREATE OR REPLACE VIEW sales_across_quarter AS

SELECT year, region, q1, q2, q3, q4

FROM sales

ROTATE (sum(sales) AS sales

FOR quarter

IN (1 AS q1, 2 AS q2, 3 AS q3, 4 AS q4));