Question

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​

Answer 1

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