1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Analyzing Business Data in SQL
Connected

Bài tập

Using CTEs

Alice wants to know how much Delivr spent per month on average during its early months (before September 2018). You'll need to write two queries to solve this problem:

  • A query to calculate cost per month, wrapped in a CTE,
  • A query that averages monthly cost before September 2018 by referencing the CTE.

Hướng dẫn 1/3

undefined XP
    1
    2
    3
  • Calculate cost per month.