一张数据库表有总库存数量，泉州库存数量，海外库存数量，,现在要转换成每个库存按照部门（B2B,B2C,主仓，内贸，DK）的库存数量，用sql写出来

要将一张包含总库存数量、泉州库存数量和海外库存数量的数据库表转换成按照不同部门（例如B2B、B2C、主仓、内贸、DK）的库存数量，需要根据具体的表结构和字段名称以及部门的分类来编写SQL语句。以下是一个通用的SQL转换示例：

SELECT
  1 AS Department, -- 假设'1'代表B2B部门
  TotalInventory - QuanzhouInventory - OverseasInventory AS B2BInventory,
  QuanzhouInventory AS QuanzhouInventory,
  OverseasInventory AS OverseasInventory
FROM InventoryTable
UNION ALL
SELECT
  2 AS Department, -- 假设'2'代表B2C部门
  TotalInventory - QuanzhouInventory - OverseasInventory AS B2CInventory,
  QuanzhouInventory AS QuanzhouInventory,
  OverseasInventory AS OverseasInventory
FROM InventoryTable
UNION ALL
SELECT
  3 AS Department, -- 假设'3'代表主仓
  TotalInventory - QuanzhouInventory - OverseasInventory AS WarehouseInventory,
  QuanzhouInventory AS QuanzhouInventory,
  OverseasInventory AS OverseasInventory
FROM InventoryTable
UNION ALL
SELECT
  4 AS Department, -- 假设'4'代表内贸
  TotalInventory - QuanzhouInventory - OverseasInventory AS DomesticTradeInventory,
  QuanzhouInventory AS QuanzhouInventory,
  OverseasInventory AS OverseasInventory
FROM InventoryTable
UNION ALL
SELECT
  5 AS Department, -- 假设'5'代表DK部门
  TotalInventory - QuanzhouInventory - OverseasInventory AS DKInventory,
  QuanzhouInventory AS QuanzhouInventory,
  OverseasInventory AS OverseasInventory
FROM InventoryTable;

在这个示例中，`InventoryTable` 是假设的表名，`TotalInventory`、`QuanzhouInventory` 和 `OverseasInventory` 是假设的字段名。每个 `SELECT` 语句中的 `UNION ALL` 被用来合并查询结果，生成新的部门库存数据。由于表结构和具体的业务逻辑未知，所以这里只是一个示例模板，实际的SQL语句需要根据具体的业务场景和数据库结构来定制。