Question

U
le
Write SQL con
No
Stars
G
a By Qty.
ruing order.
le following on the basis of given table MOV :
Table : MOV
Type
Rating
Qty
Drama
Gable
Horror
Jason
2
Drama
Cruise
Comedy PG13 Hanks
Turner
Comedy
Cruise
Ameche
PG13 Harris
IR
u t WN
Price
39.95
69.95
PG
N.
co
co
19.95
N
PG
Title
Gone with the Wind
Friday the 13th
4
Top Gun
Splash
49.95
Independence Day
Drama IR
29.95
Risky Business
Cocoon
Scifi
44.95
Crocodile Dundee
Comedy
31.95
69.95
101 Dalmatians
Comedy
59.95
Tootsie
Comedy PG Hoffman 1
29.95
Display a list of all movies with Price over 20 and sorted by Price.
(h) Display all the movies sorted by QTY in decreasing order.
Display a report listing a movie number, current value and replacement value for each
the above table. Calculate the replacement value for all movies as QTY * Price * 1.15.
​

Answer 1

Answer:

select * from mov where price>20 order by price asc;

select*from mov order by qty desc;

select movie no,current value ,qty*price*1.15 'replacement value' from mov