Assume that the Moive database contains the following tables:
MOVIES (MovieID, Title, Rating)
...
Computers and Technology, 03.04.2021 01:30 jaylanwest12
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.
Answers: 3
Another question on Computers and Technology
Computers and Technology, 22.06.2019 05:00
Which two editions of windows 7 support 64 bit cpus? choose two out of professional, business, starter, or home premium.
Answers: 1
Computers and Technology, 22.06.2019 09:00
Create a cell reference in a formula by typing in the cell name or a. right-clicking the cell. b. clicking the cell. c. clicking the column where the cell is located. d. clicking the row where the cell is located.
Answers: 1
Computers and Technology, 23.06.2019 07:00
Why were most movies from the late 1890s until the early 1930s only filmed in black and white? there were only a few people who could afford the technology to produce color motion pictures back then. audiences did not want color motion pictures until later. the film used to make color motion pictures often overheated, which was a safety hazard, so it was generally not allowed. color films had to be hand-colored, frame by frame.
Answers: 3
Computers and Technology, 24.06.2019 06:30
Adrawing that places all lines parallel to the z axis at an angle from the horizon is 99 ! a. an oblique drawing b. a perspective drawing c. an auxiliary view d. a one-point perspective drawing
Answers: 2
You know the right answer?
Questions
Mathematics, 02.08.2019 12:40
Chemistry, 02.08.2019 12:40
History, 02.08.2019 12:40
Mathematics, 02.08.2019 12:40
Chemistry, 02.08.2019 12:40
Mathematics, 02.08.2019 12:40
Social Studies, 02.08.2019 12:40
English, 02.08.2019 12:40
Mathematics, 02.08.2019 12:40
