how to find last 3 month max purchase price users

@CodeGrepperManu answered on May 26, 2023 Popularity 1/10 Helpfulness 1/10

answer how to find last 3 month max purchase price users

Comment

SELECT UserID, MAX(PurchasePrice) AS MaxPurchasePrice
FROM Purchases
WHERE PurchaseDate >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH)
GROUP BY UserID

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: find max price sql

Link to this answer
Share Copy Link

Contributed on May 26 2023

@CodeGrepperManu

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.