In-stock mid-range footwear and apparel

A merchandising manager is building a festive-season landing page and only wants products that a shopper can actually buy right now.

From catalog_products, return product_id, product_name, brand and price for every product in the Footwear or Apparel category, priced between 1000 and 3000 (both inclusive), that currently has stock available. Show the most expensive products first and break ties by product_id.

1. Step 1: Filter the category with `IN ('Footwear', 'Apparel')` instead of chaining two `OR` conditions.
2. Step 2: `BETWEEN` is inclusive on both ends, so products priced exactly 1000 and 3000 are kept.
3. Step 3: `stock_qty > 0` removes sold-out items such as Trail Sandals and Formal Shoes.
4. Step 4: Sort with `ORDER BY price DESC, product_id` so ties are deterministic.

SELECT product_id, product_name, brand, price
FROM catalog_products
WHERE category IN ('Footwear', 'Apparel')
  AND price BETWEEN 1000 AND 3000
  AND stock_qty > 0
ORDER BY price DESC, product_id;