find purchased user >5 in table

enter image description here i have table above

the question : Write a query to get the first five flight ticket purchases of each user in 2017 who have purchased flight tickets at least 5 times and have spent IDR 25 Mio. Sort from users who have highest spend, and then sort by the purchase sequence (from 1 to 5) for each user.

Expected output:

enter image description here

https://stackoverflow.com/questions/67014523/find-purchased-user-5-in-table April 09, 2021 at 11:04AM