AVG is an aggregate function that returns the average of a specified column. To get the average ticket price, try:

SELECT AVG(ticket_price) FROM flights;