SQLQuokkaSQLQuokkaEvery product launched at a price of 10. price_changes logs each later change with the date it took effect. A product's price on a date is the new_price of its most recent change on or before that date; if it had no change by then, its price is still 10. Every product that appears in price_changes must be reported. Write an SQL query that returns product_id and price as of 2025-08-16. Order the results by product_id ascending.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.