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
Simple OVER()
PARTITION BY
13. PARTITION BY – Exercise 3
Ranking functions
Window frame
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
Summary

Instruction

Good job! Let's now do some mathematic!

Exercise

Show:

  1. distinctive amount_worth values of giftcards,
  2. count of the number of giftcards with this value that were ever purchased (shown as count_1),
  3. count of all giftcards ever purchased (shown as count_2),
  4. show the percentage that the respective giftcard type constitutes in relation to all gift cards. Show the last column rounded to integer values and name it percentage.

Stuck? Here's a hint!

The last column is the most tricky one. Use ROUND(...). Inside, apply division. To avoid integer division, use CAST(column AS numeric).