case row_number() over(PARTITION BY t1.uid,t1.dt2 order by t1.dt)%7 when 3 then 3 when 0 then 7 else 1 end coin
1

相关推荐

牛客网
牛客企业服务