Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
PARTITION BY
10. OVER(PARTITION BY) – practice 2
Summary

Instruction

Another correct answer! Let's try the next exercise.

Exercise

For each ticket, show its Id, Price, the journey Date, the average price of tickets sold on that day (AvgPrice) and the number of tickets sold on that day (TicketsNumber). Exclude journeys where TrainId = 5.