My issue
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 where month='Jul' and Product_type='Low_Margin' and Division='Menswear';
update Financials set revenue=10000 where month='Aug' and Product_type='New_Products' and Division='Womenswear';
select * from Financials where month='Jul' and Product_type='Low_Margin' and
Division='Meanswear'
union
select * from Financials where month='Aug' and Product_type='New_Products' and
Division='Womenswear';
Learning course: SQL at Work
Problem Link: CodeChef: Practical coding for everyone
Iam not getting the record of july month…can anyone please hep me