我有下表，SQL fiddle 在这里：CREATE TABLE Flows(

Flow_Date DATE,

Product TEXT,

FlowType TEXT,

Quantity VARCHAR(255)

);

INSERT INTO Flows

(Flow_Date, Product, FlowType, Quantity)

VALUES

("2019-05-23","Product A","Inbound","500"),

("2019-10-08","Product A","Outbound","200"),

("2019-11-08","Product A","Outbound","100"),

("2019-11-08","Product B","Inbound","700"),

("2019-11-24","Product A","Inbound","200"),

("2019-12-14","Product A","Inbound","400"),

("2019-12-14","Product A","Outbound","300"),

("2020-12-14","Product B","Outbound","650"),

("2020-02-08","Product B","Inbound","250"),

("2020-02-15","Product A","Outbound","240"),

("2020-02-15","Product B","Outbound","170"),

("2020-02-24","Product A","Outbound","125"),

("2020-02-25","Product A","Inbound","470");

我使用以下查询来获取Inbounds和Outbounds的数量：SELECT Product, Flowtype, sum(Quantity)

FROM Flows

GROUP BY 1,2;

一切正常。

现在，我想知道是否可以在查询结果中使用Inbound和Outbound作为列名，

结果应如下所示：Inbound Outbound

Product A 1570 965

Product B 950 820

查询中需要更改什么才能使它工作？