请问最后订单价涨跌幅超过上次订单价10%的查询统计应该怎样写（自己已经写出了采购订单表并按日期和代码排序）

Question

select A.FNumber as 产品代码, A.FNAME AS 产品名称,A.FModel as 规格型号,A.F_104 as 产地,B.FName as 单位,C.FDate as 订单日期,C.FBillNo as 订单单号,D.fqty as 订单数量,D.FPrice as 订单单价,D.FtaxPrice as 订单含税单价
FROM POOrderEntry D
inner join POOrder C ON c.FInterID =d.FInterID

left join t_icitem A ON A.FItemID =D.FItemID

left join t_MeasureUnit B ON D.FUNITID = B.FItemID

WHERE AND C.fdate >='********' AND C.fdate<='########'

Answer 1

where price>price*1.1