Complete numbers 5 9 using the Ticket table found in SQLAssignment.accdb. 5. Select all ticket records listing the ticket number, passenger ID, and price for all flights arriving in PVD. 6. Select all ticket records listing ticket number, passenger ID, and Departing Airport with a price of more than $250.00. 7. Select all ticket records listing ticket number, passengerID, and Departing Airport with a price greater than $200.00 and an Arrival Airport of ORD. 8. Create a derived attribute to determine a 50% discount for all flights to PVD (the calculation for the discount is price * .50). List the ticket number, passenger ID, Departing Airport, Depart Date, and Discount Price. 9. Find the average price for all flights arriving in LAX. 10. Use a JOIN to list ticket number, passenger last name, Departing Airport, depart date, from the passenger and ticket tables with an Arriving Airport of ORD in descending order by price

'Ticket

TicketNum	FlightNum	DepartDt	DepartAirport	ArrivalDt	ArrivalAirport	Price	PassengerID
19	4359	12/23/2015	BDL	12/23/2015	ATL	$185.00	00003
17	4012	12/9/2015	MSY	12/9/2015	ATL	$225.00	00005
4	1145	9/10/2015	PVD	9/10/2015	ATL	$185.00	00002
16	2841	10/31/2015	MSY	11/1/2015	BDL	$300.00	00003
11	2184	10/23/2015	PVD	10/23/2015	BDL	$265.00	00003
10	2158	10/19/2015	PVD	10/19/2015	BDL	$245.00	00004
15	2298	10/31/2015	ORD	10/31/2015	DEN	$205.00	00005
8	2006	10/15/2015	LAX	10/15/2015	DEN	$99.00	00005
5	1142	9/17/2015	PVD	9/17/2015	DEN	$210.00	00001
22	5922	1/7/2016	DEN	1/7/2016	LAX	$99.00	00002
18	4011	12/18/2015	BDL	12/18/2015	LAX	$300.00	00004
14	2259	10/27/2015	ORD	10/27/2015	LAX	$180.00	00001
6	1146	9/21/2015	PVD	9/22/2015	LAX	$455.00	00004
9	2009	10/15/2015	LAX	10/15/2015	MCO	$300.00	00001
21	5923	1/4/2016	MCO	1/4/2016	MSY	$200.00	00004
2	1002	8/27/2015	ATL	8/27/2015	MSY	$315.00	00005
23	5992	1/29/2016	DEN	1/29/2016	ORD	$250.00	00003
13	2284	10/25/2015	ATL	10/25/2015	ORD	$225.00	00002
7	2004	10/1/2015	LAX	10/1/2015	ORD	$255.00	00001
1	1001	8/25/2015	ATL	8/25/2015	ORD	$225.00	00001
25	6822	2/28/2016	ATL	2/28/2016	PVD	$199.00	00002
24	6000	2/14/2016	DEN	2/14/2016	PVD	$199.00	00001
20	4583	12/30/2015	MCO	12/30/2015	PVD	$165.00	00001
12	2130	10/23/2015	ATL	10/24/2015	PVD	$185.00	00001
3	1003	8/29/2015	ORD	8/30/2015	PVD	$275.00	00001