Solutions:
Check these solutions from our community and artificial intelligence:
The solution above is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by product_id in descending order and then limit the results to the top 3.