CLOUDSQL: Help with query returning last three month's data

CLOUDSQL: Help with query returning last three month's data

Hi,

I have the following query:

SELECT MONTH("Table.Sales"."OrderDate") as Month,"Table.Sales"."Customer" AS Customer, "Table.Sales"."PipCode" as PipCode, "Table.Sales"."Product" as Product, MAX("Table.Sales"."UnitPrice") as Price
FROM "Table.Sales"
WHERE MONTH("Table.Sales"."OrderDate") > 7
   AND YEAR("Table.Sales"."OrderDate") = YEAR(NOW()) AND "Table.Sales"."Quote"='Y'
GROUP BY "Table.Sales"."PipCode","Table.Sales"."Product",YEAR("Table.Sales"."OrderDate"),MONTH("Table.Sales"."OrderDate")
Order BY Product, Customer

I want to be able to make the "MONTH("Table.Sales"."OrderDate") > 7" part automatic so that no matter when I run the query, it always returns data from the last three months.

Your help is much appreciated.

Shaheed