1. 创建一个 SQL 查询，并在其中包含透视表语句。
2. 使用 CREATE TABLE 创建包含透视表查询结果的新表。
3. 在新表上运行 SELECT 语句以查看透视表的结果。

以下是示例代码：

-- 创建透视表的 SQL 查询
WITH
  sales_data AS (
  SELECT
    'Product A' AS product,
    '2020-01-01' AS sale_date,
    100.0 AS sale_amount,
    'North' AS location
  UNION ALL
  SELECT
    'Product A' AS product,
    '2020-01-02' AS sale_date,
    150.0 AS sale_amount,
    'North' AS location
  UNION ALL
  SELECT
    'Product B' AS product,
    '2020-01-01' AS sale_date,
    200.0 AS sale_amount,
    'South' AS location
  UNION ALL
  SELECT
    'Product B' AS product,
    '2020-01-02' AS sale_date,
    250.0 AS sale_amount,
    'South' AS location ),
  pivot_data AS (
  SELECT
    product,
    location,
    SUM(sale_amount) AS total_sales
  FROM
    sales_data
  GROUP BY
    1,
    2 ),
  pivot_table AS (
  SELECT
    product,
    SUM(IF(location = 'North', total_sales, NULL)) AS North,
    SUM(IF(location = 'South', total_sales, NULL)) AS South
  FROM
    pivot_data
  GROUP BY
    1 )
-- 创建新表并将透视表查询结果插入其中
CREATE TABLE project.dataset.sales_pivot AS
SELECT
  *
FROM
  pivot_table;

-- 查看新表中的透视表结果
SELECT
  *
FROM
  project.dataset.sales_pivot;