BigQuery - Pivoting

Produce table at the start looks like:

Full Data Pivot

SELECT
  *
FROM
  Produce
PIVOT(SUM(sales) FOR quarter IN ('Q1', 'Q2', 'Q3', 'Q4'))

Finish pivot table looks like:

Summarised Data Pivot (Quarters Only)

SELECT
  *
FROM (
  SELECT
    product,
    sales,
    quarter
  FROM Produce
)
PIVOT(SUM(sales) FOR quarter IN ('Q1', 'Q2', 'Q3', 'Q4'))

Finish pivot table looks like:

Summarised Data Pivot (First 2 Quarters Only)

/*Alternative to just return sales figures by first 2 quarters...*/
SELECT
  *
FROM (
  SELECT
    sales,
    quarter
  FROM
    Produce
)
PIVOT(SUM(sales) FOR quarter IN ('Q1', 'Q2'))

Finish pivot table looks like: