Project 2 Iuitz (1)

docx

School

Arizona State University *

*We aren’t endorsed by this school

Course

360

Subject

Information Systems

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by PrivateFlower11235

Insert statements in a row- the first one adding a new customer, the second one adding a new ticket for that customer, should succeed. A similar two insert statements executed in the opposite order should fail Question1: Which movie sold the most tickets?

Question2 : Names of customers who have achieved EGOT status? Question3: Name of customers who have the most visits?

Question 4: Descriptions of any movie that did not sell any tickets

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Question 5: Menu Items that have not been ordered? Question 6: Items for which QOH is less than 5?

Question 7: What menu item is the most popular?

Question 8: Total Customer visits that were only for the bar Question 9: Bar Sales vs Theater Sales

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Question 10: Crew Statistics- how many customers has each crew member assisted?

Project 2 Iuitz (1)

Related Documents