Answer questions 1-6 . i need the code . thank you !Relationships – Relationships Event Plan no evento worldte notes sity mono EventRequest TO dateheld daterea facho custno daeth stus estrost estudience budno ANTO custom address Internal contact phone Employee mo empname department Event Planline phone resource Location resno resname Facility face facrame timestart timeend number locno resno Queries 1. List the city, state, and zip codes in the customer table. Your output should not have duplicates. 2. List the name, department, phone number, and email address of employees with a phone number beginning with “5”. 3. List all columns of the resource table with a rate between S10 and $20. Sort the result by rate. 4. List the event requests with a status of “Approved” or “Denied” and an authorized date in July 2005. Include the event number, authorization date, and status in the output. (Hint: Surround a date constant with pound single quotes)) 5. List the location number and name of locations that are part of the “Football stadium”. Your query must not use the facility number (“F100”) of the football stadium. Pretend that the user knows only the facility name, not the facility number 6. For each event plan, list the plan number, count of the event plan lines, and sum of the number of resources assigned. For example, plan number “P100” has 4 lines and 7 resources assigned. You only need to consider event plans that have at least one line. Show transcribed image text Relationships – Relationships Event Plan no evento worldte notes sity mono EventRequest TO dateheld daterea facho custno daeth stus estrost estudience budno ANTO custom address Internal contact phone Employee mo empname department Event Planline phone resource Location resno resname Facility face facrame timestart timeend number locno resno Queries 1. List the city, state, and zip codes in the customer table. Your output should not have duplicates. 2. List the name, department, phone number, and email address of employees with a phone number beginning with “5”. 3. List all columns of the resource table with a rate between S10 and $20. Sort the result by rate. 4. List the event requests with a status of “Approved” or “Denied” and an authorized date in July 2005. Include the event number, authorization date, and status in the output. (Hint: Surround a date constant with pound single quotes)) 5. List the location number and name of locations that are part of the “Football stadium”. Your query must not use the facility number (“F100”) of the football stadium. Pretend that the user knows only the facility name, not the facility number 6. For each event plan, list the plan number, count of the event plan lines, and sum of the number of resources assigned. For example, plan number “P100” has 4 lines and 7 resources assigned. You only need to consider event plans that have at least one line.
Expert Answer
Answer to Relationships – Relationships Event Plan no evento worldte notes sity mono EventRequest TO dateheld daterea facho custno…