Basic MySql maths!

Hi, shouldnt be too hard.

Just trying to output the price of a query.

I need the query to add all the numbers in a column, then subtract a percentage from it to produce a final number.

I came up with this

SELECT SUM(price)/100*20

FROM style

WHERE collection_month_id = '06-06-a'

GROUP BY collection_month_id;

this gives me 20 percent of the total. I hope someone can show me how i can deduct the percentage from the total!

Thanks!

just multiply by .8 which is 80%, that'll give you the price less 20%

select (price * .8) as newprice

sum will sum all the columns retrieved from your query, not sure if that's what you want or if you just want one price of a particular id?

yeah, im trying to add all the price values in the price column.

anyways, THANKS!

so simple 😛

one more thing, i want the result to be formatted to the following

0000.00

i think thats float (4,2)

how can i do this with a query? At the moment i get results like this

243.9760

etc

select (format(price * .8), 2) as newprice

something like that should work

example format is: FORMAT(X,D) // where X is value, D is decimal places

Thanks, i'll try this and get back soon!