Using Query Design, create a query to calculate the total amount of entry fees that have been collected and total number of guests registered for each event that takes$/$took place in the year $2022.$ Include EventName, EventDate, EventType, EntryFeePerGuest, TotalGuests, and Paid fields.

Name the query qryTotalPaidEntryFees$2022$

Calculate TotalEntryFees as EntryFeePerGuest $*$ TotalGuests. Name the total number of guests calculation GrandTotalGuests. You will need to specify the necessary criteria for the Paid and EventDate fields. Do not show the Paid field in the results. Sort in ascending order by EventName. Adjust the column widths as necessary. Save and close the query.