A data analyst has been asked to use the below table sales_table to get the percentage rank of products within region by the sales: The result of the query should look like this: Which of the following queries will accomplish this task?
Percent_rank is used to have ranking from 0 . Rank() returns 1 as the first number. B would be correct without GROUP BY clause. But looks better than other options ;/
Given all the other answers, B is the one that makes more sense
However the GROUP BY clause does not make sense, we are not aggregating anything in this case, and it is not even possible to run that query without having an error.
Anyone with a different idea?
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
d046bc0
1 year agoDevscope
1 year, 3 months agocsrazdan
9 months, 1 week agoMrWood47
1 year, 3 months ago