时间:2021-05-23
复制代码 代码如下:
Select top 50 UserName,sum(ReceivePrice) - sum(GuessPrice) as ReceivePrice,
cast(sum(CASE WHEN ReceivePrice>0 THEN 1.0 ELSE 0 END) / count(ReceivePrice) * 100 as numeric(4,1)) as Rate
From [game_FantasyLog]
WHERE IsJudge=1
GROUP BY UserId,UserName
ORDER BY sum(ReceivePrice) - sum(GuessPrice) ASC
复制代码 代码如下:
Select top 50 UserName,sum(ReceivePrice) - sum(GuessPrice) as ReceivePrice,
cast(sum(CASE WHEN ReceivePrice>0 THEN 1.0 ELSE 0 END) / count(ReceivePrice) * 100 as numeric(4,1)) as Rate
From [game_FantasyLog]
WHERE IsJudge=1
GROUP BY UserId,UserName Having count(UserId) >= 5
ORDER BY cast(sum(CASE WHEN ReceivePrice>0 THEN 1.0 ELSE 0 END) / count(ReceivePrice) * 100 as numeric(4,1)) ASC
复制代码 代码如下:
Select top 50 l.UserName,sum(l.GuessPrice),sum(l.ReceivePrice),f.title
From [game_FantasyLog] l left join [game_fantasy] f on l.topicid = f.id
GROUP BY l.TopicId,l.UserName,f.title
ORDER BY sum(l.GuessPrice) DESC
复制代码 代码如下:
Select top 50 f.id,f.title,f.GuessPrice,(select sum(receivePrice) FROM [game_FantasyLog] l where l.topicid = f.id),
cast((select sum(CASE WHEN ReceivePrice>0 THEN 1.0 ELSE 0 END) / f.GuessTimes FROM [game_FantasyLog] l2 where l2.topicid = f.id) as numeric(4,2))
From [game_Fantasy] f WHERE f.GuessPrice > 1000
ORDER BY (select sum(receivePrice) FROM [game_FantasyLog] l where l.topicid = f.id) ASC
复制代码 代码如下:
Select top 50 UserName,sum(ReceivePrice) as ReceivePrice
From [game_FantasyLog] where topicid=29
GROUP BY TopicId,UserName
ORDER BY sum(ReceivePrice) DESC
声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。
世界杯已经开始十几天了,小程序除了可以用来享受足球盛宴,还能给你更多实际优惠。世界杯期间扫码进入「附近优惠」小程序,就能领取各类优惠。这次小程序的活动是由微信支
2014世界杯精彩开幕了,QQ音乐携手绿钻贵族、QQ会员推出“2014畅享世界杯”活动,支持球队,获得积分,世界杯门票大奖等你来兑换,下
精品无线路由器推荐助您畅享世界杯精品无线路由器推荐助您畅享世界杯精品无线路由器推荐助您畅享世界杯精品无线路由器推荐助您畅享世界杯 产品的智能诊断功能,让家庭用
四年一次的世界杯,让人兴奋又激动!作为商家,如何捉住这次世界盛世做好世界杯热点营销,成为了头号大事。从历届世界杯来看,很多企业都做得很成功,如2012年世界
搜狐视频免流量看世界杯方法,小编将在下文介绍搜狐视频客户端免流量看世界杯活动详情,世界杯终于开赛啦~如果你想免流量用手机看直播的话,可以下载搜狐视频客户端哦