Please write sql query

8. List the plan number, event number, work date, and activity of event plans meeting the following two conditions: (1) the work date is in October 2005 and (2) the event is held in 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.

9. List the event number, event date, status, and estimated cost of events where there is an event plan managed by Mary Manager and the event is held in the football stadium in the period September 1 to December 31, 2005. Your query must not use the facility number (F100) of the football stadium or the employee number (E101) of Mary Manager. Pretend that the user knows only the facility name and employee name, not the facility number and employee number.

10. List the plan number, line number, resource name, number of resources (eventplanline.number), location name, time start, and time end where the event is held at the basketball arena, the event plan has activity of Cleanup or Setup, and the event plan has a work date in the period September 1 to December 31, 2005.

Table Listings Customer Yes Mary Manager 6857100 Boulder CO 80309 C100 Football C101 Men's Basketball Box 352400 C103 Baseball C104 Women's Softball Box 351200 C105 High School Football 123 AnvStreet Yes Sallv Supervisor 5431700 Boulder CO 80309 Yes Bill Baseb 5431234 Boulder CO 80309 Sue Sofball 5434321 BoulderCO 80309 No Coach Bob 4441234 Louisville CO 80027 E100 Chuck Coordinator Administration chuck@colorado.edu E101 Mary Manager E102 Sally Supervisor Planning E103 Alan Administrator Administration alan@colorado.edu Football co sallv@ colorado.edu F100 Football stadium F101 Basketball arena F102 Baseball field F103 Recreation room Location L100 F100 Locker room L101 F100 Plaza L102 F100 Vehicle gate L103 F101 Locker room L104 F100 Ticket Boot L105 F101 Gate L106 F100 Pedestrian gate Resource R100 attendant R105 food service $10.00 EventRequest eventno dateheld datereg facno custno dateauth status estcost estaudience budno 80000 B1000 25-Oct-2005 06-Jun-2005 F100 C100 08-Jun-2005 Approved E100 E101 26-0ct-2005 28-Jul-2005 F100 C100 E102 14-Sep-2005 28-Jul-2005 F100 C100 31-Jul-2005 Approved $5,000.00 E103 $$,000.00 80000 B1000 21-Sep-2005 28-Jul-2005 F100 C100 01-Aug-2005 Approved 03-Dec-2005 28-Jul-2005 FI01 CI0 31-Jul-2005 Approved 05-Dec-2005 28-Jul-2005 F101 C101 01-Aug-2005 Approved 12-Dec-2005 28-Jul-2005 FI01 CI01 31-Jul-2005 Approved$2,000.00 23-Nov-2005 28-Jul-2005 F100 C105 31-Jul-2005 Denied 12000 B1000 10000 B1000 10000 B1000 S2,000.00 $10,000.00 E107 Dr. Mustafa Atay