Consider$-$the Q$1$ in A$02$ where we created triggers to update the count of events in CFPCount table. We are interested in adding another summary table CFPList which contains only two columns: EventID and EventType. EventID is the PK attribute that is present in the three event tables: EventConference, EventJournal and EventBook and it is unique across the three tables. EventType can have one of the three values: 'Conference', 'Journal' or 'Book'. Each row in this table represents an event and its type.

a$.$ Write a statement to create the CFPList table.

$[2$ Marks$]$

b$.$ Write a trigger that adds a new row to the CFPList table whenever a new row is inserted in the EventConference table.

$[3$ Marks$]$

c$.$ Write a query to retrieve the count of different eyent types from the CFPList.

$[2$ Marks$]$