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 11:00

When building customer relationships through email what should you not do? question 2 options: utilize proper grammar, spelling, and punctuation type in all capital letters use hyperlinks rather than attachments respond to all emails within 24 hours

Answers: 1

Answer

Computers and Technology, 22.06.2019 16:30

You have inserted new slides based on a word outline. how do you format these new slides to match the powerpoint presentation formatting? a. select all slides in the presentation and click format on the home tab. b. select the new slides and click reset on the home tab. c. select all slides in the presentation and click reset on the home tab. d. select the new slides and click format on the home tab.

Answers: 2

Answer

Computers and Technology, 24.06.2019 00:50

3. what is the output of the following statements? temporary object1; temporary object2("rectangle", 8.5, 5); temporary object3("circle", 6, 0); temporary object4("cylinder", 6, 3.5); cout < < fixed < < showpoint < < setprecision(2); object1.print(); object2.print(); object3.print(); object4.print(); object1.set("sphere", 4.5, 0); object1.print();

Answers: 1

Answer

Computers and Technology, 24.06.2019 03:30

What is the purpose of a computer network needs assessment? to analyze which workers need more training to improve their performance to compare worker productivity to determine what steps employees can take to increase company revenue to evaluate how to move from the current status to the desired goal

Answers: 2

Answer

You know the right answer?

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

Questions