Find the net profit of each movie showing its ID, Name and Net Profit.
(Hint: Net Profit = BusinessCost – ProductionCost)
Make sure that the new column name is labeled as NetProfit. Is this column now a part of the MOVIE relation. If no, then what name is coined for such columns? What can you say about the profit of a movie which has not yet released? Does your query result show profit as zero?
Attachments:
Answers
Answered by
1
Answer:
ufiffufuufufig fuufduufdududyuf
Answered by
12
Answer:
Select MovieID, MovieName, BusinessCost - ProductionCost as NetProfit From Movies;
Explanation:
You Just Need To Select MovieId, MovieName
and Then BusinessCost - ProductionCost as NetProfit .from the table you created to store the information of Movies
If You Do Not Understand Tell Me I will Explain you In A more Easier Way.
I am In the 11th class Too And this question Was Teasing Me A lot, but I figured out How To do it.
Similar questions