Question

System.
DRAM and OSS.
6
(21
Consider the following table named "GYM" with details about Fitness products
being sold in the store.
[9]
Table Name: GYM
PrCode stores Codes of Products
PrName stores names of Products
(Unit Price is in Rs.)
PrCode PrName
UnitPrice Manufacturer
7101 Cross Trainer
25000 Avon Fitness
1102 Tread Mill
32000
AG Fitline
P103 Massage Chair 20000 Fi Express
P104 Vibration Trainer 22003
Avon Fitness
P105
Bike
13000
Fit Express
1)
Write SQL statements to do the following:
a) Display the names of all the products in the store.
b) Display the names and unit price of all the products in the store
Display the names of all the products with unit price less than Rs 20000.00
d) Display details of all the products with unit price in the range 20000 to 30000
Display names of all products by the manufacturer Fit Express
Display all rows sorted in descendingorder of unit price.
Add a new row for product with the details: *P706", Vibro Exerciser", 23000,
manufacturer: "Avon Fitness
h) Change the Unit Price data of all the rows by applying a 10% discount
reduction on all the products.
1) Display details of all products with manufacturer name starting with "A"​

Answer 1

Answer:

System.

DRAM and OSS.

6

(21

Consider the following table named "GYM" with details about Fitness products

being sold in the store.

[9]

Table Name: GYM

PrCode stores Codes of Products

PrName stores names of Products

(Unit Price is in Rs.)

PrCode PrName

UnitPrice Manufacturer

7101 Cross Trainer

25000 Avon Fitness

1102 Tread Mill

32000

AG Fitline

P103 Massage Chair 20000 Fi Express

P104 Vibration Trainer 22003

Avon Fitness

P105

Bike

13000

Fit Express

1)

Write SQL statements to do the following:

a) Display the names of all the products in the store.

b) Display the names and unit price of all the products in the store

Display the names of all the products with unit price less than Rs 20000.00

d) Display details of all the products with unit price in the range 20000 to 30000

Display names of all products by the manufacturer Fit Express

Display all rows sorted in descendingorder of unit price.

Add a new row for product with the details: *P706", Vibro Exerciser", 23000,

manufacturer: "Avon Fitness

h) Change the Unit Price data of all the rows by applying a 10% discount

reduction on all the products.

1) Display details of all products with manufacturer name starting with "A"