subject

Assume that the Moive database contains the following tables: MOVIES (MovieID, Title, Rating)
THEATERS (TheaterID, TheaterName)
LOCATION (LocationID, City, State, TheaterID)
TICKETS (TheaterID, MovieID, SaleDate, TicketSold)
Create the SQL syntax and use comment lines for the following request:
a. List the movie titles showing at the Paradise and Majestic theaters. Use a subquery.
b. List all rated R movie titles and grand total ticket sales for showing with ticket sales greater than 20.
c. List unrated movie titles that sold more than 10, but exclude the city of Yorba Linda location.
d. List the movie titles and profit amounts for each showing. Each movie showing earns 20% profit from its ticket sales. Assume individual ticket price is $12.50.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 17:30
Working on this program in python 3.7: a year in the modern gregorian calendar consists of 365 days. in reality, the earth takes longer to rotate around the sun. to account for the difference in time, every 4 years, a leap year takes place. a leap year is when a year has 366 days: an extra day, february 29th. the requirements for a given year to be a leap year are: 1) the year must be divisible by 42) if the year is a century year (1700, 1800, the year must be evenly divisible by 400some example leap years are 1600, 1712, and 2016.write a program that takes in a year and determines whether that year is a leap year.ex: if the input is 1712, the output is: 1712 is a leap year. ex: if the input is 1913, the output is: 1913 is not a leap year. your program must define and call the function isleapyear(useryear). the function should return true if the input year is a leap year and false otherwise.
Answers: 1
question
Computers and Technology, 22.06.2019 19:20
How might the success of your campaign be affected if you haven’t carefully completed all field data or if you accidentally insert the wrong merge field in the document?
Answers: 2
question
Computers and Technology, 23.06.2019 06:40
What are the three uses of a screw?
Answers: 2
question
Computers and Technology, 23.06.2019 14:00
Technician a says that with self-adjusting clutch systems, the release bearing constantly rotates. technician b says that the ball bearing portion of the release bearing should be lubricated with high-temperature grease during routine maintenance. which technician is correct?
Answers: 2
You know the right answer?
Assume that the Moive database contains the following tables: MOVIES (MovieID, Title, Rating)
...
Questions
question
Physics, 23.04.2021 05:40
question
Mathematics, 23.04.2021 05:40
question
Mathematics, 23.04.2021 05:40
Questions on the website: 13722363