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 in MS SQL Server

Introduction
5. The SingleRental Table
Simple OVER()
PARTITION BY
Ranking functions
Window Frames
Analytic Functions
PARTITION BY ORDER BY
Order of Evaluation
Finished!

Instruction

Ok, but what's the connection between customers and the store?

Exercise

Now let's get down to business. One thing customers can do is rent a single movie for a certain period of time.

Select all the information from the SingleRental table. Each rental has:

  • an Id,
  • a RentalDate (when the rent period starts),
  • a RentalPeriod (in days),
  • a Platform used to view the movie (desktop, mobile or tablet_,
  • a CustomerId,
  • a MovieId,
  • a PaymentDate (which can be after the rental date),
  • a PaymentAmount.