Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions

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.