I'm trying to sum the total in MYSQL database. But i'm getting this " invalid use of group function" error. Please tell any one how to fix this error.
Select sum(Price*(1+sum(tax)/100))*Quantity as totalcartamount from tblshoppingcart where sessionid='eo5rzewlcc4gmhltem0kimu4' group by id;