4. Consider the following MOVIE database and answer the SQL queries based on it.
MovielD MovieName Category Release Date Production Cost Business Cost
001 Hindi Movie Musical
2018/04/23
124500
130000
002 Tamil Movie
Action
2016/05/17 112000
118000
003 English_Movie Horror
2017/08/06 245000
360000
004 Bengali Movie Adventure 2017/01/04
72000
100000
005
Telugu_Movie Action
100000
006 Punjabi_Movie
Comedy
30500
a. Write command to create the table MOVIE.
b. Retrieve movies information without mentioning their column names.
c. List business done by the movies showing only MovieID, MovieName and BusinessCost.
d. List the different categories of movies.
e. Find the net profit of each movie showing its ID, Name and Net Profit
(Hint:- Net Profit=Business Cost-Production Cost)
f. SELECT * FROM MOVIE where Category =”Comedy”;.
g. SELECT MovieName, Category,MovieID from MOVIE where ReleaseDate is NULL;
Answers
Answered by
0
Answer:
(a) (b) (c) (d) (e) (f) (g).all the answer
Similar questions