Write SQL commands for the following on the basis of given table MOV (a) Display a list of all movies with Price over 20 and sorted by Price.

Q. Write SQL commands for the following on the basis of given table MOV :

(a) Display a list of all movies with Price over 20 and sorted by Price.

(b) Display all the movies sorted by QTY in decreasing 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.

Answer =

(a)
Select title from MOV
Where price > 20
Order by price ;

(b)
Select title from MOV
Order by QTY desc ;

(c)
Select no, price, qty* price * 1.15 as replacement_value from MOV ;