1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Business Data in SQL

Exercise

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.

Instructions 1/3

undefined XP
    1
    2
    3
  • Calculate cost per month.