Joined
·
741 Posts
Cant test anything until I'm back at work. Been trying to use SQL+ for about a day now.
My question is
http://www.w3schools...ql_func_avg.asp
The example they show is
Quote:
My example table called "purchase":
Car price purchase Date
smcar £10 01/12/2014
smfar £20 03/12/2014
In my case will this be "SELECT AVG(price) as PriceAverage FROM purchase" ?
My question is
http://www.w3schools...ql_func_avg.asp
The example they show is
Quote:
They did AVG(price) which gets the price but then they have "PriceAverage". Is that a new name?SELECT AVG(Price) AS PriceAverage FROM Products;
My example table called "purchase":
Car price purchase Date
smcar £10 01/12/2014
smfar £20 03/12/2014
In my case will this be "SELECT AVG(price) as PriceAverage FROM purchase" ?