drop table if exists t_fuel;

create table t_fuel (
 f_id int not null primary key,
 fuel varchar( 100 ) not null
);

insert into t_fuel values ( 1 , 'Бензин'), ( 2 , 'Керосин'), ( 3 , 'Уголь');


drop table if exists t_towns;

create table t_towns (
 t_id int not null primary key,
 town varchar( 255 ) not null
);

insert into t_towns values ( 1 , 'Вологда'), ( 2 , 'Киров'), ( 3 , 'Москва');


drop table if exists t_prices;

create table t_prices (
 p_id int not null auto_increment primary key,
 price int not null default  0 ,
 fuel_id int not null default  0 ,
 town_id int not null default  0 
);

insert into t_prices (price, fuel_id, town_id) values 
 ( 1252 ,  1 , 1 ), ( 4545 ,  2 ,  1 ), ( 87 ,  3 ,  1 ),
 ( 47 ,  1 ,  2 ), ( 12 ,  2 ,  2 ), ( 78 ,  3 ,  2 ),
 ( 78 ,  1 ,  3 ), ( 564 ,  2 ,  3 ), ( 789 ,  3 ,  3 );

select town, sum(gas) as gas, sum(kerosine) as kerosine, sum(coal) as coal
from 
 (select 
   t.town,
   t.t_id town_id,
   if (fuel_id= 1 , price,  0 ) as 'gas',
   if (fuel_id= 2 , price,  0 ) as 'kerosine',
   if (fuel_id= 3 , price,  0 ) as 'coal'
   from t_prices p, t_towns t
   where t.t_id=p.town_id
 ) x
group by town_id

town        gas  kerosine  coal  
-------  ------  --------  ------
Вологда    1252      4545      87
Киров        47        12      78
Москва       78       564     789