20. Write SOL command for the following on the basis of given table:
Table: MOV
Type Rating Stars Qty Price
(3)
1
Gone with the Wind
Drama
G
Gable
2
Friday the 13"
Horror
R
Janson
2
Top Gun
Drama
PG
Cruise
7
Splash
Comedy PG13
Hanks
3
29.95
Independence Day
Drama
R
Turner
3
19.95
Risky Business
Comedy R
Cruise
2
7
Cocoon
Scifi
Ameche
2
(A) Display a list of all movies with price over 20 and sorted by price.
(B) Display all the movies sorted by OTY in decreasing order
(C) Display a report listing a movie name. current value for each movie
in the above table Calculate the current value for all movies as
traffiti
Share
it's the output
No Name Type Rating Stars Qty price
1 Gone with wind Drama G Gable 4 39.95
2 Friday the 13
th
Horror R Jason 2 60.95
3 Top Gun Drama PG Cruise 7 49.95
4 Splash Comedy PG13 Hanks 3 29.95
5 Independent day Drama R Turner 3 19.95
6 Risk Business Comedy R Cruise 2 44.95
7 Cocoon Sci-fi PG Ameche 2 31.95
8 Crocodile Comedy PG13 Harris 2 69.95
9 101 Dalmatians Comedy G Hoffman 3 59.95
10 Tootsie Comedy PG Croft 1 29.95