Introduction
7. Table giftcard
Simple OVER()
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.

Console

Code editor

Result

TableConsole