SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedQuery-Based Questionsm2 storage index mvcc internals

Latest Active Catalog Version

Write SQL to return product_id, version_no, and updated_at for the latest active version of each product in product_versions where status = 'ACTIVE'.

Schema Context

product_versions(product_id, version_no, status, updated_at)