Write a query to find events in the highest 99.9 percentile for all-time gross sales.
Hint: The structured query language (SQL) ntile function will return a dataset into a group of buckets as specified by the function's argument. For example, ntile(1000) orders will return the highest 99.9 percentile for a dataset of orders.
Write a query to find events in the highest 99.9 percentile for all-time gross sales. Hint: The structured query languag
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Write a query to find events in the highest 99.9 percentile for all-time gross sales. Hint: The structured query languag
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!