Question

consider the following sales table and write the queries
Table:salesSale​

Answer 1

Answer:

a) SELECT * FROM SalesSale;

b) SELECT * FROM SalesSale WHERE `Sale amount`>150000;

c) UPDATE SalesSale SET `Sale date`='2005-03-18 00:00:00.000' WHERE SaleId='1003';