Question

Consider the following table –Mobile Master and answer the following queries:​

Answer 1

(i) select * from MobileMaster where M_Price >4000;

(ii) select sum(M_Price), avg(M_Price) from MobileMaster where M_Company = "Nokia";

(iii) select * from MobileMaster order by M_Price desc;

(iv) update MobileMaster set M_Mf_Date = "2016-02-02" where M_Id = "MB001";

(v) delete from MobileMaster where M_Id = "MB005";

(vi) select M_Company from MobileMaster where M_Id = "MB006";

(vii) select * from MobileMaster where M_Id = "Sony";

(viii) alter table MobileMaster drop column M_Name;