By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*(SELECT MIN(sales) FROM product_sales), sales/2.0 ) OVER (ORDER BY year) AS no_' at line 2