Leetcode Problem 1098. Unpopular Books

1098. Unpopular Books

Leetcode Solutions

Filtering and Aggregating Sales Data

Calculate the date one month before the current date (2019-05-23).
Select all books that have been available before this calculated date.
Calculate the date one year before the current date (2018-06-23).
Aggregate the total quantity of books sold from the orders table for each book between the date one year ago and the current date.
Use a LEFT JOIN to combine the books and aggregated sales data.
Filter the combined data to find books with total sales less than 10 copies.
Select the required columns (book_id and name) for the final output.

erDiagram
    Books {
        int book_id PK
        varchar name
        date available_from
    }
    Orders {
        int order_id PK
        int book_id FK
        int quantity
        date dispatch_date
    }

Using Subqueries for Filtering and Aggregation

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 1098. Unpopular Books

Leetcode Solutions

Filtering and Aggregating Sales Data

Solution Idea

Query Steps

Code Implementation

Using Subqueries for Filtering and Aggregation

Ask Question

Suggested Answer