SQL Query to Sum Quantity Values with the Same ID Using SQL

How to Resolve "0 row(s) modified" Error When Using Row Number() Over (Partition By) in MySQL with Outer Join