mysql - SQL查询以查找击球手在powerplay中的最高击球率（1-6以上）

Question

select overs,(sum(batsman_runs)/count(batsman_runs))*100 as Strike_rate,batsman from IPL_BALL_BY_BALL where overs between 1 and 6 group by batsman;

我试过这个有点错误。overs -- 1-20，表名 = IPL_BALL_BY_BALL，batsman_runs = 击球手的跑动，击球手 - 击球手的名字

标签： mysqlsql

Answer 1

你错过了 group by。仅当您需要每个轮次的罢工率时，您才应该添加轮次。在这种情况下，请试试这个，

select 
overs
,batsman
,(sum(batsman_runs)/count(batsman_runs))*100 as Strike_rate
from IPL_BALL_BY_BALL 
where overs between 1 and 6 
group by overs, batsman;

如果你想为 powerplay 计算这个，那么试试这个，

select 
batsman
,(sum(batsman_runs)/count(batsman_runs))*100 as Strike_rate
from IPL_BALL_BY_BALL 
where overs between 1 and 6 
group by batsman;