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
PARTITION BY
9. OVER(PARTITION BY) – practice 1
Summary

Instruction

Fantastic! Let's do a couple of practice exercises.

Exercise

For each journey, show its Id, the ProductionYear of the train on that journey, the number of journeys that train made (as TrainJourneys) and the number of journeys on that same route (as RouteJourneys).

Stuck? Here's a hint!

Use COUNT(Journey.Id) twice, but with a different OVER(PARTITION BY) clause. Join two tables.