Question
write Relational Query of those SQL code A) SELECT location.locno, customer.custName FROM location,customer,facility WHERE facility.facNo= F100 wwwwww b) SELECT eventrequest.evnt No, eventrequest.custNo, customer.phone, eventrequest.dateReq, facility.facno,
A) SELECT location.locno, customer.custName FROM location,customer,facility WHERE facility.facNo= "F100" wwwwww b) SELECT eventrequest.evnt No, eventrequest.custNo, customer.phone, eventrequest.dateReq, facility.facno, facility.facname, (eventrequest.estCost/eventrequest.estAudience) AS estimated audience cost per person C) FROM eventrequest, customer, facility www. www WHERE eventrequest.custno = customer.custno AND eventrequest.facNo = facility.facno AND eventrequest.dateReq BETWEEN "2013-01-01" AND "2013-07- 31" AND (eventrequest.estCost/eventrequest.estAudience) >0.1
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
Programming With Microsoft Visual Basic 2017
Authors: Diane Zak
8th Edition
1337102121, 9781337517058, 978-1337102124
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
View Answer in SolutionInn App