mysql - coldfusion

[Samurai_Sjakkie]

how can i translate the following to work in a clodfusion query?
i want it to give me the amount of items ordered. the total cost and the
total vat paid. but as the vat is a percentage of the cost i need to divide it
by 100 and then bij the average VAT....

select sum(Quantity) , sum(Cost) , sum(Cost)/100 * avg(VAT)
from Purchases
Order BY Quantity

[PaulH *ACE*]

Samurai_Sjakkie wrote:

> how can i translate the following to work in a clodfusion query?
> i want it to give me the amount of items ordered. the total cost and the
> total vat paid. but as the vat is a percentage of the cost i need to divide it
> by 100 and then bij the average VAT....
>

not sure what you're asking but maybe something like this?

SELECT SUM(Quantity) AS quantitySum, SUM(Cost) AS costSum, SUM(Cost)/100 *
AVG(VAT) AS something
FROM Purchases

since this should return only one row i guess you won't need the ORDER BY clause.