RE: VERY URGENT question about calculating average

["Muthukumar Selvarasu" <muthukumar_se@xxxxxxxxxxx>]

Hi 

 

here solution for your problem

 

CREATE TABLE `table_name` (

  `id` int(11) NOT NULL auto_increment,

  `city` varchar(255) default NULL,

  `price` float default NULL,

  PRIMARY KEY  (`id`)

)

insert into `table_name` (`id`,`city`,`price`) values (1,'sydney',10);

insert into `table_name` (`id`,`city`,`price`) values (2,'melbourne',20);

insert into `table_name` (`id`,`city`,`price`) values (3,'sydney',30);

insert into `table_name` (`id`,`city`,`price`) values (4,'melbourne',10);

insert into `table_name` (`id`,`city`,`price`) values (5,'sydney',20);

insert into `table_name` (`id`,`city`,`price`) values (6,'melbourne',30);

insert into `table_name` (`id`,`city`,`price`) values (7,'sydney',39);

insert into `table_name` (`id`,`city`,`price`) values (8,'melbourne',449);

insert into `table_name` (`id`,`city`,`price`) values (9,'melbourne',22);

insert into `table_name` (`id`,`city`,`price`) values (10,'melbourne',111);

 

 

Answer

 

1.                   select city, sum(price) from table_name group by city

2.                   select city, count(price) from table_name group by city

 

 

Thanks,

Muthukumar Selvarasu,

Project Manager (Web Development),

Webmasters Ltd.

 

  _____  

From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On
Behalf Of Sudhakar
Sent: Thursday, December 13, 2007 12:12 AM
To: php-objects@xxxxxxxxxxxxxxx
Subject:  VERY URGENT question about calculating average

 

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.

 



[Non-text portions of this message have been removed]