Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
7. Product Price on a Specific Date
On this page

Problem Statement

Table: PriceChanges
This table records the price changes of various products. Each row includes a product ID, the new price of the product, and the date when this new price became effective.

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| product_id    | int     |
| new_price     | int     |
| effective_date| date    |
+---------------+---------+
(product_id, effective_date) is the primary key for this table.
Each row in this table indicates that the price of a product was changed to a new price on a specific date.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page