You have a table named ProductCounts that contains 1000 products as well as the number of units
that have been sold for each product. You need to write a query that displays the top 5% of products
that
have been sold most frequently.
Which TransactSQL
code segments should you use?
A.
WITH Percentages AS (
SELECT *, NTILE(5) OVER (ORDER BY UnitsSold) AS groupingColumn
FROM ProductCounts)
SELECT *
FROM percentages
WHERE groupingColumn =1;
B.
WITH Percentages AS (
SELECT *, NTILE(5) OVER (ORDER BY UnitsSold) AS groupingColumn
FROM ProductCounts)
SELECT *
FROM Percentages
WHERE groupingColumn = 5;
C.
WITH Percentages AS (
SELECT *, NTILE(20) OVER (ORDER BY UnitsSold) AS groupingColumn
FROM ProductCounts)
SELECT *
FROM Percentages
WHERE groupingColumn = 1;
D.
WITH Percentages AS (
SELECT *, NTILE(20) OVER (ORDER BY UnitsSold) AS groupingColumn
FROM ProductCounts)
SELECT *
FROM Percentages
WHERE groupingColumn = 20;