Window Functions in MS SQL Server | Online Course | Vertabelo Academy

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

30/31 Grouping by NTILE

1. Welcome to the Practice Field

2. The Customer Table

3. The Movie Table

4. The Review Table

5. The SingleRental Table

6. The Subscription Table

7. The GiftCard Table

8. OVER() – Review and Exercise 1

9. OVER() – Exercise 2

10. OVER() – Exercise 3

11. PARTITION BY – Review and Exercise 1

12. PARTITION BY – Exercise 2

13. PARTITION BY – Exercise 3

14. PARTITION BY – Exercise 4

15. Ranking Functions – Review and Exercise 1

16. Ranking Functions – Exercise 2

17. Ranking Functions – Exercise 3

18. Ranking Functions – Exercise 4

19. Window Frames – Review and Exercise 1

20. Window Frames – Exercise 2

21. Window Frames – Exercise 3

22. Window Frames – Exercise 4

23. Analytic Functions – Review and Exercise 1

24. Analytic Functions – Exercise 2

25. Analytic Functions – Exercise 3

26. PARTITION BY ORDER BY – Review and Exercise 1

27. PARTITION BY ORDER BY – Exercise 2

28. PARTITION BY ORDER BY – Exercise 3

29. Ranking of Platforms

30. Grouping by NTILE

31. Congratulations

Exactly right! Are you ready to take on the final question?

Divide subscriptions into three groups (buckets) based on the PaymentAmount. Group the rows in the Subscription table based on those buckets. Show the following information: the Bucket, the minimal PaymentAmount in that bucket (column MinPaymentAmount) and the maximal PaymentAmount in that bucket (column MaxPaymentAmount).

Use NTILE(3) in a subquery and rename it Bucket. In the outer query, use it to group the rows.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.