Leetcode Problem 1384. Total Sales Amount by Year

1384. Total Sales Amount by Year

Leetcode Solutions

Calculating Total Sales Amount Per Year Using Date Ranges

Create a Common Table Expression (CTE) or a derived table that generates a series of dates for each year within the range of period_start and period_end from the Sales table.
Join the Product table with the CTE or derived table on product_id.
Filter the dates to include only those within the period_start and period_end range for each product.
Group the results by product_id, product_name, and year, and calculate the sum of average_daily_sales for each group.
Order the final result by product_id and year.


erDiagram
    Product {
        int product_id PK
        varchar product_name
    }

    Sales {
        int product_id PK
        date period_start
        date period_end
        int average_daily_sales
    }

    Product ||--o{ Sales : contains

Using Yearly Subqueries to Calculate Total Sales

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 1384. Total Sales Amount by Year

Leetcode Solutions

Calculating Total Sales Amount Per Year Using Date Ranges

Solution Idea

Query Steps

Code Implementation

Using Yearly Subqueries to Calculate Total Sales

Ask Question

Suggested Answer