Page 1 of 1

Write a query to find events in the highest 99.9 percentile for all-time gross sales. Hint: The structured query languag

Posted: Sat May 14, 2022 4:31 pm
by answerhappygod
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.