Question
3) For the following Schema: CUSTOMER(CustomerID, CustName, CustEmail, CustAddress, CustCity, CustState, CustZip, CustPhone) SALE(EventID, CustomerID, Quantity) EVENT(EventID, EventDate, EventTime, Show, SeatingCapacity, Price) 3.1 Write a
3) For the following Schema: CUSTOMER(CustomerID, CustName, CustEmail, CustAddress, CustCity, CustState, CustZip, CustPhone) SALE(EventID, CustomerID, Quantity) EVENT(EventID, EventDate, EventTime, Show, SeatingCapacity, Price)
3.1 Write a query that will print the customer name, email, EventDate, EventTime, and quantity for all sales.
3.2 What is the query that will print the EventIDs for all events that either occur in October 2008 and cost less than $20, or occur in November 2008 and cost less than $30.
3.3 What is the query that will print the name and average price of all shows
3.4 What is the query that will print the name and average price of all shows. Only include shows where the average price is greater than $10.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Accounting Information Systems
Authors: Marshall B. Romney, Paul J. Steinbart
13th edition
133428532, 978-0133428537
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App