Introduction
PARTITION BY
Ranking functions
Window frame
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
Summary
Instruction
And there is yet one option to spend money in the store.
Exercise
Select all the information from the giftcard table.
The last thing you can purchase are giftcards for someone else. Each giftcard has an id, amount_worth (30, 50 or 100 dollars to spend in our store), customer_id, payment_date and payment_amount.
