Consider the following MOVIE table and answer the SQL queries based on it.
List MovieID, MovieName and BusinessCost from the table.
Display the movieID which is having production cost greater than 100000.
Display the details of Action movies
Answers
Answer:
01 Visit remaining as a guest
You have limited access to toppr answr. Sign to unlock 35 lakh questions
answr
Whats your doubt?
search
Computer Science
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 Total_Earning. Total_Earning 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.
Answer
Open in answr app
solution
Answer verified by Toppr
323 Views
Was this answer helpful?
Related questions
Using the sports database containing two relations(TEAM, MATCH_DETAILS) and write the queries for the following:
a) Display the MatchID of all those matches where both the teams have scored more than 70.
b) Display the MatchID of all those matches where FirstTeam has scored less than 70 but SecondTeamhas scored more than 70
c) Display the MatchID and date of matches played by Team 1 and won by it.
d) Display the MatchID of matches played by Team 2 and not won by it.
e) Change the name of the relation TEAM to T_DATA.