Latest price per product
 

Return the most recent price for a given product in the table, sorted by product in increasing order.

These are the tables to query for this question:
bootcamp.product_prices
    Your answer should include these columns:
    • product_id bigint
    • price double
    • effective_date date

    Querying is only for logged in users!

    Sign In

    Query Results