SELECT product_id,
       COALESCE(NULLIF(stock, 0), 'Out of Stock') AS stock_status
FROM inventory;