CASE
  WHEN v_qty > 100 THEN v_label := 'Bulk';
  WHEN v_qty > 10  THEN v_label := 'Medium';
  ELSE v_label := 'Small';
END CASE;
