问如何用BigQuery模拟一个数据透视表？

EN

-- top revised Wikipedia articles containing 'Google'
WITH articles AS (
  SELECT title AS page_title,
         COUNT(*) AS total
    FROM `publicdata.samples.wikipedia`
   WHERE REGEXP_CONTAINS(title, r'^Google.+') AND wp_namespace = 0
   GROUP BY title
   ORDER BY total DESC
   LIMIT 5
)

SELECT page_title,
       -- Populate these columns as True or False, depending on the condition
       IF(page_title LIKE '%search%', total, 0) AS search,
       IF(page_title LIKE '%Earth%' OR page_title LIKE '%Maps%', total, 0) AS geo
  FROM articles
;