Find Product Prices
Using the table playground.product_prices, create a SQL query to find all products and their prices on 2023-08-17, assuming the initial price of all products was 10 before any price changes. Order the results in ascending order of product_id.
These are the tables to query for this question:
playground.product_prices- product_id int
- new_price int
- change_date date
Your answer should include these columns:
- product_id integer
- price integer
Querying is only for logged in users!
Write Your Query Here (you can run selections by highlighting!)
Query Results
No queries have been run yet.