write Relational Query of those SQL code A) SELECT location.locno, customer.custName FROM location,customer,facility WHERE facility.facNo= F100 wwwwww

write Relational Query of those SQL code 

 

Transcribed Image Text:

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 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