Question: Question 5 20 pts Background: The database schema below is for movie theaters located in Orange County. The system keeps track of movie showings,

Question 5 20 pts Background: The database schema below is for movie

Question 5 20 pts Background: The database schema below is for movie theaters located in Orange County. The system keeps track of movie showings, sales, customer reward accounts, and theater owner details. Owners may own more than one theater in various locations. Tickets sales consists of the number of tickets sold and the $18 price per ticket. Use the following database schema to write your SQL statement. MOVIES(MovieID, Title, Rating, Description) THEATERS(TheaterID, TheaterName, Address, ZipCode, OwnerID) OWNERS(OwnerID, FName, LName, Address, ZipCode, Phone, Email) TICKET_SALES(TSID, MSID, RewardID, Sales Date, Quantity) MOVIE_SHOWINGS(MSID, MovieID, TheaterID, ShowingDate, Time) CUSTOMER_REWARDS(RewardID, CustFName, CustLName, Address, ZipCode, Phone, Email) ZIPCODE(ZipCode, City, State) REVIEWS (ReviewID, MovieID, Review Rating, Comments) Write an SQL statement that will: List the movie titles and its ratings for movies being listed and showing in Huntington Beach for Tuesday, May 17, 2022, but only for the StarPlex theaters with more than 350 tickets sold.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Choose a speech or piece of writing that has elements of "the sublime". Explain what ways Longinus's theory is at work in the selection. Cite the sublime piece that is selected. Compare Augustine's...

Instructions: Enter your SQL statement in the textbox provided. Be sure to apply the rules and framework necessary that would give minimal errors if executed. It is important to provide a response as...

hello there read this case and answer the question belw thanks THE ALAMO DRAFTHOUSE The Alamo Drafthouse is a different kind of business, whether you call it a bar, a restaurant, or a movie theater....

Using the pages below, answer the following questions; Chapter 10 Read P.218- 223 Answer 223 Q.1-3 Read P.224-234 Answer P.234 Q.1-3 AS YOU READ . -. . YOU WILL LEARN ' To dene entertainment...

Please answer the question below. You need to read the imaginary case Tesla-motorcycles in order to answer the questions. -What are the primary components of Tesla Motorcycles value chain? The answer...

IDEO Case Study Assignment What are features of IDEO's "Exploratory Phase"? (select all that apply) Team members share different insights they have gained in downloading sessions Extended interviews...

SUMMARY OF LEARNING OBJECTIVES AND KEY POINTS 1. Identify the basic elements of organizations. Organizations are made up of a series of elements: Designing jobs Grouping jobs Establishing reporting...

The following bank reconciliation statement for Mona Company for the month ended on November 30 2018: Required: 1- Compute the missing amount (The Balance per cash Book). (1 Point) Mona Company Bank...

S & X Co. is a retail store owned solely by Paul Turner. During the month of November, the equity accounts were affected by the following events: Nov. 9 Turner invested an additional $15,000 in the...

tions are common shares. The corporations are Multiple Choice associated due to control by unrelated groups. not associated. associated due to control by one person and a group of persons. associated...

How do geneticists design an assay for a genetic screen? 3 (12pt) Arial

A solid dielectric spacer is poorly embedded in a 10mm spaced parallel electrode gap which is to be stressed at 26kV p under standard atmospheric conditions (discharge inception=3.0kV/mm). Due to...

Q2). Given the function below complete the following tasks: y = f(x) = x + x 6 %3D a). Graph the function showing all intercepts, turning points, and state the domain and range b). Graph the...

1) The following table lists the joint probability distribution between recipients of the Nobel prize in economics and the other five prizes, and the citizenship of the recipients, based on the...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Defi ne HR planning and outline the HR planning process. LO1

Discuss two possible contributors to competitive advantage and how HR contributes to each. LO1

Describe how legal, political, cultural, and economic factors affect global HR management. LO1