1. 学习
    2. /
  2. 课程
    3. /
  3. Introduction to BigQuery
Connected

练习

Using multiple CTEs

Using multiple CTEs can greatly improve the performance and legibility of code. In this example, you will split a query into two CTEs to make it easier to read and more performant.

说明 1 / 共 2 个

undefined XP
    1
    2
  • Create a new CTE named orders that will extract the order_id column along with the product_id and price from the nested order_items column, all from the ecommerce.ecomm_orders table.
  • Filter for price greater than 100.