YoY Revenue Growth

Problem

The marketing team needs a report showing sales growth compared to the previous year. Write a query that outputs concept with the value: "YoY growth is calculated by joining a monthly sales subquery with itself lagged by 12 months, or using the LAG(sales, 12) window function."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution