Question

Write SQL command for the following table Movie

Answer 1

a)

SELECT DISTINCT TITLE

FROM Movie;

b)

SELECT TITLE

FROM Movie

WHERE PRICE>200

ORDER BY RATING;

BY default ORDER BY will give output in ascending order. To get output in descending order. You can write ORDER BY RATING DESC.

c)

SELECT Sum(SEATS_LEFT)

FROM Movie

WHERE TYPE = 'ACTION' ;

d)

SELECT No as 'Movie Number', PRICE as 'Current Price', (PRICE + PRICE*0.15) as 'Updated Price'

FROM Movie;