Write SQL commands for the queries (i) to (iv) and output for (v) to (viii) based on the tables ‘Watches’ and ‘Sale’ given below :
(i) To display all the details of those watches whose name ends with ‘Time’.
(ii) To display watch’s name and price of those watches which have price range iii between 5000-15000.
(iii) To display total quantity in store of Unisex type watches.
(iv) To display watch name and their quantity sold in first quarter.
(v) SELECT MAX(Price), MIN(Qty_Store) FROM Watches;
(vi) SELECT Quarter, SUM(Qty_Sold) FROM Sale GROUP BY Quarter;
(vii) SELECT Watch_Name, Price, Type FROM Watches w, Sale s WHERE w.Watchid!=s.Watchid;
(viii) SELECT Watch_Name, Qty_Store, SUM(Qty_Sold), Qty_Store SUM(Qty_Sold) "Stock" FROM Watches w, Sale s WHERE w.Watchid=s.Watchid GROUP BY s.Watchid;