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 leaving

a blank question will be detrimental to the exam grade.

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$($MovielD$,$ Title, Rating, Description$)$

THEATERS$($TheaterID$,$ TheaterName, Address, ZipCode, OwnerID$)$

OWNERS$($OwnerID$,$ FName, LName, Address, ZipCode, Phone, Email$)$

TICKET$\_$SALES$($TSID$,$ MSID, RewardID, SalesDate, Quantity$)$

MOVIE$\_$SHOWINGS$($MSID$,$ MovieID, TheaterID, ShowingDate, Time$)$

CUSTOMER$\_$REWARDS$($RewardID$,$ CustFName, CustLName, Address, ZipCode, Phone, Email$)$

ZIPCODE$($ZipCode$,$ City, State$)$

REVIEWS$($ReviewID$,$ MovieID, ReviewRating, Comments$)$

Write an SQL statement that will:

List the movie titles and total sales for movie showings in Fullerton on Friday, April $5,2024$ except for those movies with a grand total of sales of more than $$500.$ Sort by movie titles.