presently there is a table which records information about users enquiring for fares to a particular destination. in the existing report which is a php file when a particular date is selected this php file will display the total number of enquiries for each destination and its price for a particular dates. in this php file a select query is executed along with GROUP BY and ORDER BY ex= DESTINATION PRICE sydney 1000 melbourne 2500 perth 2000 sydney 2000 sydney 3000 my question is 1. i would like to add all sydney fares and find the average and similarly for other cities. ex= DESTINATION PRICE sydney 500 melbourne 200 2. i would like to display the city which had the maximum number of enquiries to the city with minimum enquiries in a descending order with the numeric value. please provide the code for 1 and 2. thanks in advance.
