This is a plain theory / code task question — you are given a table and asked to write seven specific SQL queries.

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

SELECT * FROM Movie;

SELECT * retrieves every column and every row. This is the simplest possible query — no filtering, no calculation.

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

SELECT MovieID, MovieName, ProductionCost + BusinessCost AS Total_Earning
FROM Movie;

The + operator adds the two numeric columns. AS Total_Earning gives the computed column a meaningful alias. Note that rows with NULL in either cost column will produce NULL for Total_Earning — that is correct behaviour in SQL.

(c) List the different categories of movies.

SELECT DISTINCT Category FROM Movie;

DISTINCT eliminates duplicate values, so each category appears only once. The result will be: Musical, Action, Horror, Adventure, Comedy.

(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.

SELECT MovieID, MovieName, BusinessCost - ProductionCost AS NetProfit
FROM Movie;

Subtraction works the same way as addition. Again, any row with a NULL in either cost will show NULL for NetProfit.

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

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

The WHERE clause filters rows. AND requires both conditions to be true. The alias Cost renames the column in the output. Only Bengali_Movie (72000) and Punjabi_Movie (30500) satisfy this range.

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

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

OR includes rows matching either condition. The string comparison is case-sensitive in most SQL implementations — the table uses 'Comedy' and 'Action' exactly as written. This returns Tamil_Movie, Telugu_Movie, and Punjabi_Movie.

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

SELECT * FROM Movie
WHERE ReleaseDate IS NULL;

A movie that has not been released has no date stored — that is a NULL, not an empty string or a future date. You must use IS NULL, not = NULL. This returns Telugu_Movie and Punjabi_Movie.

This is a query task with multiple sub-parts (a) through (g). I will answer each sub-part in order, providing the SQL query and a brief explanation of the key clause or logic used.

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

SELECT * FROM Movie;

This is the simplest query — SELECT * retrieves every column and every row from the table. The * is a wildcard meaning "all columns".

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

SELECT MovieID, MovieName, ProductionCost + BusinessCost AS Total_Earning
FROM Movie;

The key idea here is a calculated column. You can perform arithmetic directly in the SELECT clause. The AS keyword gives a name to the result column. Note that if either ProductionCost or BusinessCost is NULL, the sum will also be NULL — that's correct behaviour for the given data (Movie 005 and 006 have no BusinessCost, so their Total_Earning will be NULL).

(c) List the different categories of movies.

SELECT DISTINCT Category FROM Movie;

DISTINCT eliminates duplicate rows from the result. Without it, you'd get every category for every movie, including repeats. With DISTINCT, you get each category only once.

(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.

SELECT MovieID, MovieName, BusinessCost - ProductionCost AS NetProfit
FROM Movie;

Again, a calculated column. The order matters: BusinessCost - ProductionCost gives profit (positive if the movie earned more than it cost to produce). For movies with NULL in either column, the result will be NULL.

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

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

The WHERE clause filters rows. The condition uses AND to combine two comparisons. Note that the column alias Cost is given to ProductionCost in the output. The values 10,000 and 1,00,000 are written without commas in SQL (commas are not allowed in numeric literals).

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

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

The OR operator includes rows that satisfy either condition. String comparisons in SQL are case-sensitive by default in many systems (though MySQL is case-insensitive by default). The values in the table are 'Comedy' and 'Action' with capital first letters, so the query matches exactly.

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

SELECT * FROM Movie
WHERE ReleaseDate IS NULL;

This is the critical one. The table shows - for ReleaseDate for movies 005 and 006, which in SQL means NULL. You cannot write WHERE ReleaseDate = NULL — that will never be true because NULL is not equal to anything. The correct operator is IS NULL.