Plz help me with this...answer the following question on the basis of the table given below
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?
This question has not been answered yet!