1. เรียนรู้
    2. /
  2. Courses
    3. /
  3. Analyzing Business Data in SQL
Connected

Exercises

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.

คำแนะนำ 1 / 3

undefined XP
    1
    2
    3
  • Calculate cost per month.