Consider the following MOVIE table and write the SQL queries based on it.

MovieID	MovieName	Category	ReleaseDate	ProductionCost	BusinessCost
001	Hindi_Movie	Musical	2018-04-23	124500	130000
002	Tamil_Movie	Action	2016-05-17	112000	118000
003	English_Movie	Horror	2017-08-06	245000	360000
004	Bengali_Movie	Adventure	2017-01-04	72000	100000
005	Telugu_Movie	Action	-	100000	-
006	Punjabi_Movie	Comedy	-	30500	-

(a) Display all the information from the Movie table.

(b) List business done by the movies showing only MovieID, MovieName and TotalEarning. TotalEarning to be calculated as the sum of ProductionCost and BusinessCost.

(c) List the different categories of movies.

(d) Find the net profit of each movie showing its MovieID, MovieName and NetProfit. Net Profit is to be calculated as the difference between Business Cost and Production Cost.

(e) List MovieID, MovieName and Cost for all movies with ProductionCost greater than 10,000 and less than 1,00,000.

(f) List details of all movies which fall in the category of comedy or action.

(g) List details of all movies which have not been released yet.

(a)

SELECT * FROM Movie;

Output

+---------+---------------+-----------+-------------+----------------+--------------+
| MOVIEID | MOVIENAME     | CATEGORY  | RELEASEDATE | PRODUCTIONCOST | BUSINESSCOST |
+---------+---------------+-----------+-------------+----------------+--------------+
|       1 | Hindi_Movie   | Musical   | 2018-04-23  |         124500 |       130000 |
|       2 | Tamil_Movie   | Action    | 2016-05-17  |         112000 |       118000 |
|       3 | English_Movie | Horror    | 2017-08-06  |         245000 |       360000 |
|       4 | Bengali_Movie | Adventure | 2017-01-04  |          72000 |       100000 |
|       5 | Telugu_Movie  | Action    | NULL        |         100000 |         NULL |
|       6 | Punjabi_Movie | Comedy    | NULL        |          30500 |         NULL |
+---------+---------------+-----------+-------------+----------------+--------------+

(b)

SELECT MovieID, MovieName, (ProductionCost + BusinessCost) AS Total_Earning
FROM Movie
WHERE ReleaseDate IS NOT NULL;

Output

+---------+---------------+---------------+
| MovieID | MovieName     | Total_Earning |
+---------+---------------+---------------+
|       1 | Hindi_Movie   |        254500 |
|       2 | Tamil_Movie   |        230000 |
|       3 | English_Movie |        605000 |
|       4 | Bengali_Movie |        172000 |
+---------+---------------+---------------+

(c)

SELECT DISTINCT Category FROM MOVIE;

Output

+-----------+
| Category  |
+-----------+
| Musical   |
| Action    |
| Horror    |
| Adventure |
| Comedy    |
+-----------+

(d)

SELECT MovieID, MovieName, BusinessCost - ProductionCost AS NetProfit
FROM Movie
WHERE ReleaseDate IS NOT NULL;

Output

+---------+---------------+-----------+
| MovieID | MovieName     | NetProfit |
+---------+---------------+-----------+
|       1 | Hindi_Movie   |      5500 |
|       2 | Tamil_Movie   |      6000 |
|       3 | English_Movie |    115000 |
|       4 | Bengali_Movie |     28000 |
+---------+---------------+-----------+

(e)

SELECT MovieID, MovieName, ProductionCost AS Cost
FROM MOVIE
WHERE ProductionCost > 10000 AND ProductionCost < 100000;

Output

+---------+---------------+-------+
| MovieID | MovieName     | Cost  |
+---------+---------------+-------+
|       4 | Bengali_Movie | 72000 |
|       6 | Punjabi_Movie | 30500 |
+---------+---------------+-------+

(f)

SELECT * FROM MOVIE
WHERE Category = 'Comedy' OR Category = 'Action';

Output

+---------+---------------+----------+-------------+----------------+--------------+
| MOVIEID | MOVIENAME     | CATEGORY | RELEASEDATE | PRODUCTIONCOST | BUSINESSCOST |
+---------+---------------+----------+-------------+----------------+--------------+
|       2 | Tamil_Movie   | Action   | 2016-05-17  |         112000 |       118000 |
|       5 | Telugu_Movie  | Action   | NULL        |         100000 |         NULL |
|       6 | Punjabi_Movie | Comedy   | NULL        |          30500 |         NULL |
+---------+---------------+----------+-------------+----------------+--------------+

(g)

SELECT * FROM MOVIE
WHERE ReleaseDate IS NULL;

Output

+---------+---------------+----------+-------------+----------------+--------------+
| MOVIEID | MOVIENAME     | CATEGORY | RELEASEDATE | PRODUCTIONCOST | BUSINESSCOST |
+---------+---------------+----------+-------------+----------------+--------------+
|       5 | Telugu_Movie  | Action   | NULL        |         100000 |         NULL |
|       6 | Punjabi_Movie | Comedy   | NULL        |          30500 |         NULL |
+---------+---------------+----------+-------------+----------------+--------------+