Xorthax needs to group products into 4 tiers based on their current stock levels currently available at his trading post. Write a query to assign stock tiers for each product category.