Question

a) Retrieve movies information without mentioning their
column names.
b) List business done by the movies showing only
MovieID, 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)​

Answer 1

a) Retrieve movies' information without mentioning their column names.

• Select * from Movies;

b)  List businesses done by the movies showing only MovieID, MovieName and Business Cost.

• Select M_ID, M_Name, BusinessCost from Movies;

c) List the different categories of movies.

• Select distinct Category from Movies;

d) Find the net profit of each movie showing its ID, Name and Net Profit.

• Select M_ID, M_Name, BusinessCost - ProductionCost as 'Net Profit' from Movies;

I'm attaching the assumed table for these queries below: