34,594
社区成员
发帖
与我相关
我的任务
分享
Create table User01
(
uid varchar(5),
dt date,
p1 float,
p2 float
)
Create table User02
(
uid varchar(5),
weight float
)
Create table Result
(
dt date,
CV float
)
;with cte as(
select U1.uid, U1.dt, (U1.p1-U1.p2)*U2.weight as New_p from User01 as U1
inner join User02 as U2
on U1.uid=U2.uid
)
insert into Result
select dt, STDEV(New_p)/AVG(New_p) as CV from cte
group by dt