3 Marks Each

Question

Write SQL queries for (a) to (d) and find outputs for SQL queries (e) to (i), which are based on the tables.

TABLE: WATCHES

TABLE: SALE

(a) To display all the details of those watches whose name ends with ‘time’

(b) To display watch’s name andprice of those watches which have price range between 5000-15000

(c) To display total quantity in store of unisex type watches

(d) To display watch name and their quantity sold in first quarter

(e) Select max(price),min(qty_store) from watches;

(f) Select quarter, sum(qty_sold) from sale group by quarter;

(g) Select watch_name,price,type from watches w, sale s where w.watchid=s.watchid;

(h) Select watch_name, qty_store, sum(qty_sold),qty_store

(i) W.watch=s.watchid group by s.watchid;

Vidyadip · Accepted Answer

(a) select * from watches where watch_name like ‘%TIME’;

(b) select Watch_name, Price from Watches where price between 5000 and 15000;

OR

Select Watch_name, Price from Watches where Price>=5000 and Price<=15000;

(c) Select sum(Price) from Watches where Type=’UNISEX’;

(d) Select Watch_name, Qty_sold from Watches, Sale where Watches. Watchid = Sale. Watchid and Quarter = 1;

(e)

(f)

watch_name	price	type
HighFashion	7000	Unisex

Answer