Display the count of each event type grouped based on the calendar months i.e., how many events of each type happening in the months for which the data is present in the database. You need to show the output only for those months which are present in the database. For EventConference we will consider the EvDate field while for the other two event types, Journal and Book, it will be the ActivityDate of the earliest/lowest activity (from ActivityHappens). You can show this query as three different queries for each event type.
Display the one upcoming event for each event type i.e., the event with the lowest date value but in the future from the current date. Assume the current date is “January 01, 2017”. For all event types, it will be the ActivityDate of the earliest/lowest activity (from ActivityHappens). You can show this query as three different queries for each event type.
Below is the SQL codes
When click on Event Conferences
When click on Event Books