Question

SQL> Select PERCENT_RANK() OVER (ORDER BY Price) as PerentageRank, ArtID, price as p from Arts; PERENTAGERANK ARTID P ----- ? A0111 174.69 .090909091 A0104 174.99 .181818182 A0103 179.99 .272727273 A0112 189.39 .363636364 A0102 189.59 .454545455 A0106 219.99 .545454545 A0108 274.89 .636363636 A0113 289.49 .727272727 A0109 289.99 .727272727 A0107 289.99 .909090909 A0105 314.99 PERENTAGERANK ARTID 1 A0110 12 rows selected. P 316.99

          SQL> Select PERCENT_RANK() OVER (ORDER BY Price) as PerentageRank, ArtID, price as p from Arts;
PERENTAGERANK ARTID
P
-----
? A0111
174.69
.090909091 A0104
174.99
.181818182 A0103
179.99
.272727273 A0112
189.39
.363636364 A0102
189.59
.454545455 A0106
219.99
.545454545 A0108
274.89
.636363636 A0113
289.49
.727272727 A0109
289.99
.727272727 A0107
289.99
.909090909 A0105
314.99
PERENTAGERANK ARTID
1 A0110
12 rows selected.
P
316.99

SQL> Select PERCENTRANK() OVER (ORDER BY Price) as PerentageRank, ArtID, price as p from Arts;
PERENTAGERANK ARTID
P
—–
? A0111
174.69
.090909091 A0104
174.99
.181818182 A0103
179.99
.272727273 A0112
189.39
.363636364 A0102
189.59
.454545455 A0106
219.99
.545454545 A0108
274.89
.636363636 A0113
289.49
.727272727 A0109
289.99
.727272727 A0107
289.99
.909090909 A0105
314.99
PERENTAGERANK ARTID
1 A0110
12 rows selected.
P
316.99

Added by Cindy C.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Liam Haas-Neill

Step 1

The question asks for the percentile rank for the same price. In this case, the price is given in the "price" column of the Arts table. Show more…

Show all steps

Thanks for your feedback!

My instructions tell me to round my answer to the nearest whole number. Would it be talking about the price? How would I round my answer? Question: In the same Arts table, find the percentile rank for the same price. Pay attention to how the percentile rank is typically expressed (as a percent?). Round your answer to the nearest whole number. SQL Select Statement: Select PERCENT_RANK() OVER (ORDER BY Price) as PercentageRank, ArtID, price as p from Arts; PERCENTAGERANK ARTID A0111 090909091 A164 .181818182 A13 .272727273 A112 .363636364 A12 .454545455 A16 .545454545 A18 .636363636 A113 .727272727 A0109 .727272727 A17 909090909 A15 174.69 A0116 316.99 rows selected.