Writes querry

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.

-9List 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. -

Relationships == Relatioriships LO X plano eventno PANDIt Notes activity Vto daleheld datereg faCNO CUSTO dateamuth status estCOst ESCACIETICE odo Custname address Internal Contact DOR en City State budo DEparter Evenianure EstFI euca reso