(a) Write the SQL queries: 1. To display Name and Price of all the Accessories in ascending order of their Price.

Question

Answer the questions (a) and (b) on the basis of the following tables SHOP and ACCESSORIES.

(a) Write the SQL queries:

1. To display Name and Price of all the Accessories in ascending order of their Price.

2. To display Id and SName of all Shop located in Nehru Place.

3. To display Minimum and Maximum Price of each Name of Accessories.

4. To display Name, Price of all Accessories and their respective SName where they are available.

(b) Write the output of the following SQL

1. SELECT DISTINCT NAME FROM ACCESSORIES WHERE PRICE> =5000;

2. SELECT AREA, COUNT(*) FROM SHOPPE GROUP BY AREA;

3. SELECT COUNT (DISTINCT AREA) FROM SHOPPE;

4. SELECT NAME, PRICE*0.05 DISCOUNT FROM ACCESSORIES WHERE SNO IN (‘S02‘,S03‘);

Answer 1

(a)

1. SELECT Name, Price FROM ACCESSORIES ORDER BY Price Asc;

2. SELECT ID SName FROM SHOP WHERE Area=”Nehru Place”;

3. SELECT Name, max (Price); min(Price) FROM ACCESSORIES, Group By Name;

4. SELECT Name,price, Sname FROM 

ACCESSORIES, SHOP WHERE SHOE 

ID=ACCESSORIES.ID;

(b)