Write the querry

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.

7- For event requests, list the event number, event date (eventrequest.dateheld) , and count of the event plans. Only include event requests in the result if the event request has more than one related event plan with a work date in October 2005.

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