Question

1. Create a table GARMENTS with PrCode as the primary key. Decide your own data types. Insert records as
shown in the table below and write the queries for the following:
Table: GARMENTS
PrCode
Category
Brand
Price
Year OfManufacture
TR01 Trouser Richlook
4000 2016
SH01 Shirt Peter England 900 2017
TE01 Tie
Richlook
1500 2017
TS01 T-Shirt Puma
800 2015
TRO2 Trouser
Levis
4500 2015
TEO2 Tie
Peter England 1500 2016
a. Display the details of all garments in ascending order of Price.
5. Display the Brand and Price of the Category Trouser'.
Display the Category and Price of all the products manufactured before 2016.
Increase the Price of all the items by 5%.
Remove the details of all the garments under Levis brand.​

Answer 1

Answer:

Select * from GARMENTS order by Price;

Select Brand, Price from GARMENTS where Category= 'Trousers';

Select Category, Price from GARMENTS where Year of Manufacturer < '2016';

Delete from GARMENTS where Brand='Levis';

Answer 2

Answer:

The complete Solution is give in the picture above.....

Hope u like it.....