The following table presents information about flight reservations of an airline company. Use VBA to perform the following:

TktNo	CustomerId	FlightNo	Class	BookingDate	TravelDate	NoInfants	MealPref	PaymentMode	PayAmt
1	C001	1	Economy	2/5/2002	3/5/2001	0	Asian Veg	Check	$210.00
2	C003	1	Business	4/5/2002	5/5/2003	1	Non Veg	Cash	$210.00
3	C003	1	Business	5/14/2002	6/14/2003	1	Non Veg - Dairy	Credit card	$360.00
4	C007	2	Economy	12/1/2001	1/1/2003	2	Non Veg	Credit Card	$230.00
5	C009	2	Business	4/5/2002	5/5/2003	0	Asian Veg	Credit Card	$360.00
6	C010	3	Economy	2/3/2002	3/3/2003	0	Asian Veg	Check	$310.00
7	C014	3	Economy	6/7/2002	6/7/2003	0	Non Veg - Dairy	Credit card	$310.00
8	C012	3	Club	6/7/2002	6/7/2003	1	Non Veg	Credit Card	$560.00
9	C003	4	Economy	5/3/2002	8/3/2003	1	Veg	Credit Card	$130.00
10	C004	4	Economy	5/20/2002	6/20/2003	0	Asian Veg	Credit Card	$130.00
11	C011	5	Economy	12/7/2001	3/7/2003	0	Asian Veg	Credit Card	$210.00
12	C012	5	Club	4/1/2002	7/1/2003	0	Asian Veg	Credit Card	$510.00
13	C014	6	Business	4/2/2002	7/2/2003	1	Non Veg - Dairy	Check	$160.00
14	C013	6	Club	6/1/2002	9/1/2003	0	Non Veg - Dairy	Credit Card	$260.00

a. Create a sub that presents the number of customers that have a reservation for flight with FlightNr 1 to flight with FlightNr 6.

b. Create a sub that calculates the average amount of payments made.

c. Create a sub that finds the maximum and minimum payment amount.

d. Create a sub that calculates the total amount made from Economy class flights, Club and Business class.