Question

.
IVIHIV
ix
Write SQL queries for the following on the basis of given table MOV (1)
No
Title
Type
Rating
Stars
Qty
Price
Gone with the Wind
Drama
G
Gable
14
39.95
2
Friday the 13th
Horror
IR
Jason
69.95
Top Gun
Drama
PG
Cruise
17
49.95
4
Splash
Comedy | PG13
Hanks
29.95
Independence Day
Drama
IR
Turner
13
19.95
a) Find the total value of the movie cassettes available in the library.
b) Display a list of all movies with Price over 20 and sorted by Price in descending
order.
c) Display a report listing a movie-number, current value and replacement value for
each movie in the above table. Calculate the replacement value for all movies as
Qty*Price*1.15.
d) Count the number of movie where Rating is not "G"​

Answer 1

Explanation:

I don't know what the hell happened with the question about related to you