Based on the same schema, what will the following statement produce:

select $*,$ rank$()$ over $($partition by category orders by price desc$)$ as price $\_$rank

from item

order by price$\_$rank, name

Assume Item table has:

itemid name category price

A$2523$ m&ms candy

$$1\mathrm{.}60$

A$2533$ nut barssnack bars

$$3\mathrm{.}00$

A$3223$ reeces candy

$$1\mathrm{.}00$

A$3003$ truffles candy

$$1\mathrm{.}60$

B$3066$ oat barssnack bars

$$4\mathrm{.}00$