SQL Avg Help

[1nstan7]

http://www.w3schools.com/sql/sql_func_avg.asp

 

The example they show is

SELECT AVG(Price) AS PriceAverage FROM Products;

 

 

They did AVG(price) which gets the price but then they have "PriceAverage". Is that a new varible?

 

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" ?

 

If so how would I do this and show only purchases after 02/12/2014?

Edited January 4, 2015 by 1nstan7

[davej]

If your column name for the date is purchasedate then try...

SELECT AVG(price) AS MyLABELFROM purchaseWHERE purchasedate >= '2014-02-13'

[1nstan7]

 

If your column name for the date is purchasedate then try...

SELECT AVG(price) AS MyLABELFROM purchaseWHERE purchasedate >= '2014-02-13'

 

Thank you!