hmmm, lets try that again... sorry about this...

column names are total_liters, price_a_liter, total_dollars

i have tried your select line and SQL do not like it heheeh(my mistake) just tried it again and it works, my fingers get in the way sometimes...heheeeh

but when i tired this...

select AVG(total_liters), AVG(total_dollars), AVG(price_a_liter) from Petrol_Table where FuelDate like '2014-06%'

it gave me this result col1 = 38.715, col2=55.8075, col3=143.7

which is correct, thanks very much for the lesson.:-D