My issue
Parse error near line 25: near “where”: syntax error
n =‘Menswear’ and product_type = ‘Low_margin’) or where (month =‘Aug’ and divi
error here —^
My code
/* Write a query which does the following
- Update the table to reflect these entries
Revenue in 'Jul' for 'Low_margin' 'Menswear' needs to be updated to 25000
Revenue in 'Aug' for 'New_products' 'Womenswear' needs to be updated to 10000
- Output all entries of these 2 rows to validate that the updates have been completed */
update financials
set revenue =25000 and revenue =10000
where (month ='Jul' and division ='Menswear' and product_type = 'Low_margin')
or where (month ='Aug' and division ='Womenswear' and product_type = 'New_products');
Learning course: SQL at Work
Problem Link: Case study - Covid impact on ABC Retail Practice Problem in SQL at Work - CodeChef