a) Retrieve movies information without mentioning their column names. b) List business done by the movies showing only MovielD, MovieName and Business Cost. List the different categories of movies. d) Find the net profit of each movie showing its ID, Name and Net Profit. (Hint: Net Profit = Business Cost - Production Cost)
Answers
Answered by
12
A.Retrieve movies information without mentioning their column names
- Select - From movies:
B.List businesses done by the movies showing only Movie I'd , Moviename And Businesses cost.
- Select Movie- ID _ Movie-Name , Businesses cost from movie's
C.List the different categories of movies.
- Select distinct category from movie's
D.Find the net profit of each movie showing its ID , Name And net profit.
- Select Movie-ID, Movie-Name , Business cost , prosecution cost As , Net profit' from Movie's
I'm attaching The assumed Table for these queries below:
Attachments:
Similar questions