Computer Science, asked by Crystal2003, 10 months ago


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 yshsnj
1

Answer:

ufiffufuufufig fuufduufdududyuf

Answered by yashbharwdaj
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