(using sql developer): query formulation problems

1.List the event number, customer name, contact name, and authorization date where the event request has been approved but there is not an event plan. (20 points)

2.List the plan number, count of the lines in the plan, and the sum of the resource cost for event plans at the Basketball arena with a work date in December 2018. You should only include event plans with at least one event plan line. The resource cost is the number of hours times the number of resources times the rate of the resource. In Oracle, the number of hours can be computed as (TimeEnd TimeStart) * 24. You should use the entire expression inside the SUM function. Your query must not use the facility number (F101) of the basketball arena. Pretend that the user knows only the facility name, not the facility number. Thus, the WHERE clause should not have a condition involving the facility number compared to a constant (F101). (20 points)

3.List the event number, date requested, date authorized, plan number, work date, and name of the supervising employee of events meeting the following conditions: (1) the date requested and date authorized are in July 2018, (2) the event request has Approved status, and (3) there is at least one event plan. Include a row in the result even if there is no supervising employee for the event plan. (20 points)

4.List event plan details (event plan number, work date, activity, employee number, employee name, and employee department) along with the count of event plan lines, and count of unique resources used in associated event plan lines. Use meaningful names for computed columns. Include an event plan in the result even if the event plan does not have a supervising employee. Only include event plans with a work date in December 2018. Only include event plans using more than one unique resource. Order the result by event plan number.