Page 2 :
Q. Consider the following tables STORE and SUPPLIERS. | —_, Write SQL commands for the statements (i) to (iv) and, give outputs for SQL queries (v) to (viii). — —, , , , , , , , , , , , , , , Table: Store <—, , , , , , Premium Stationery, , , , Soft Plastics, , Tetra Supply, , Item No, , , , , , , , , , , Sharpener Classic 31-Jun-09, , v) Eexket » {vm Sto ve, ORDERBY Loot baw 3, , , , Ball Pen 0.25 22 50 25 01-Feb-10, , Gel Pen Premium 150 12 4-Feb 10, , 11-Mar-09, , , , , , Gel Pen Classic, , , , ie) Sele ct vtemNo tem, , Eraser Small 19-Jan-09, , , , , , Eraser Big 02-Dec-09, , Ball Pen 0.5 03-Nov-09, , ui To display details of all the items in the Store table in ascending order of LastBuy., , To display Itemno and item name of those from Store table whose rate is more than 15 rupees.
Learn better on this topic
