USING MySQL:

Copy the code under the question to receive credit.

1a. List the event number, date held, customer number, customer name, facility number, and facility name of 2013 events placed by Boulder customers.

b. List the customer number, customer name, event number, date held, facility number, facility name, and estimated audience cost per person (EstCost / EstAudience) for events held on 2013, in which the estimated cost per person is less than $0.2.

c. List the customer number, customer name, and total estimated costs for Approved events. The total amount of events is the sum of the estimated cost for each event. Group the results by customer number and customer name.

d. Insert yourself as a new row in the Customer table.

e. Increase the rate by 10 percent of nurse resource in the resource table.

f. Delete the new row added to the Customer table.

EVENTREQUEST CUSTOMER EVENTNO DATEHELD DATEREQ CUSTNO CUSTNO CUSTNAME ADDRESS INTERNAL CONTACT PHONE CITY STATE ZIP FACILITY FACNO F FACNO FACNAME DATEAUTH STATUS ESTCOST ESTAUDIENCE BUDNO EVENTPLAN PLANNO EVENTNO WORKDATE NOTES ACTIVITY EMPNO EMPLOYEE EMPNO EMPNAME DEPARTMENT EMAIL PHONE LOCATION LOCNO FACNOo LOCNAME EVENTPLANLINE PF PLANNO RESOURCETBL RESNO RESNAME RATE LINENO TIMESTART TIMEEND NUMBERFLD LOCNO RESNO