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

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 16:10

Drag each label to the correct location on the imagelist the do’s and don’ts of safeguarding your password.keep yourself loggedin when you leave your computer.don’t write your password down and leave it whereothers can find it.share your password with your friends.each time you visit a website,retain the cookies on your computer.use a long password with mixed characters.

Answers: 1

Answer

Computers and Technology, 23.06.2019 01:30

Jason works as an accountant in a department store. he needs to keep a daily record of all the invoices issued by the store. which file naming convention would him the most? a)give the file a unique name b)name the file in yymmdd format c)use descriptive name while naming the files d)use capital letters while naming the file

Answers: 3

Answer

Computers and Technology, 23.06.2019 02:00

Which demographic challenge is europe currently experiencing? a. an aging and decreasing population b. a baby boomc. an unequal distribution between males and females d. a large group of teenagers moving through the school system(i chose a but i'm unsure)

Answers: 1

Answer

Computers and Technology, 23.06.2019 19:50

Which feature is selected to practice and save the timing of a presentation

Answers: 1

Answer

You know the right answer?

Assume that the Moive database contains the following tables: MOVIES (MovieID, Title, Rating)
...

Questions