WITH RankedReviews AS (
    SELECT 
        p.product_name, 
        r.review_text, 
        r.submit_date,
        ROW_NUMBER() OVER (PARTITION BY p.product_id ORDER BY r.submit_date DESC) as rnk
    FROM reviews r
    JOIN products p ON r.product_id = p.product_id
)
SELECT product_name, review_text, submit_date
FROM RankedReviews
WHERE rnk = 1;