Xorthax wants to understand how popular each product is relative to others in its category. Write a query that assigns each product a relative position based on total quantity sold, expressed as a percentage of its category's ranking.