SELECT
p.product_name,
p.category,
SUM(s.units_sold) AS total_quantity_sold,
SUM(s.units_sold*s.unit_price) AS total_revenue
FROM product p
INNER JOIN sales s ON s.product_id=p.product_id
WHERE EXTRACT(YEAR FROM s.sale_date) = 2023
GROUP BY p.product_name
ORDER BY total_quantity_sold DESC
LIMIT 5
