Vryjdfkk

select d.innings_no,

       e.Player_Name,

       (@total := @total + ifnull(sum(b.runs_scored) + sum(c.extra_runs), 0)) as Runs,

       count(b.runs_scored)                                                      Balls

from wicket_taken d

       inner join ball_by_ball a on d.match_id = a.match_id and d.player_out in (a.striker, a.non_striker)

       left join batsman_scored b

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (b.match_id, b.over_id, b.ball_id, b.innings_no)

       left join extra_runs c

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (c.match_id, c.over_id, c.ball_id, c.innings_no)

       inner join Player e on d.player_out = e.Player_Id

       cross join

       (select @total := 0) params

where d.match_id = 335987

group by d.player_out, d.innings_no

order by d.player_out asc;

select d.innings_no,

       e.Player_Name,

       (@total := @total + ifnull(sum(b.runs_scored) + sum(c.extra_runs), 0)) as Runs,

       count(b.runs_scored)                                                      Balls

from wicket_taken d

       inner join ball_by_ball a on d.match_id = a.match_id and d.player_out in (a.striker, a.non_striker)

       left join batsman_scored b

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (b.match_id, b.over_id, b.ball_id, b.innings_no)

       left join extra_runs c

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (c.match_id, c.over_id, c.ball_id, c.innings_no)

       inner join Player e on d.player_out = e.Player_Id

       cross join

       (select @total := 0) params

where d.match_id = 335987

group by d.player_out, d.innings_no

order by d.player_out asc;

select d.innings_no,

       e.Player_Name,

       (@total := @total + ifnull(sum(b.runs_scored) + sum(c.extra_runs), 0)) as Runs,

       count(b.runs_scored)                                                      Balls

from wicket_taken d

       inner join ball_by_ball a on d.match_id = a.match_id and d.player_out in (a.striker, a.non_striker)

       left join batsman_scored b

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (b.match_id, b.over_id, b.ball_id, b.innings_no)

       left join extra_runs c

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (c.match_id, c.over_id, c.ball_id, c.innings_no)

       inner join Player e on d.player_out = e.Player_Id

       cross join

       (select @total := 0) params

where d.match_id = 335987

group by d.player_out, d.innings_no

order by d.player_out asc;

select d.innings_no,

       e.Player_Name,

       (@total := @total + ifnull(sum(b.runs_scored) + sum(c.extra_runs), 0)) as Runs,

       count(b.runs_scored)                                                      Balls

from wicket_taken d

       inner join ball_by_ball a on d.match_id = a.match_id and d.player_out in (a.striker, a.non_striker)

       left join batsman_scored b

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (b.match_id, b.over_id, b.ball_id, b.innings_no)

       left join extra_runs c

                 on (a.match_id, a.over_id, a.ball_id, a.innings_no) = (c.match_id, c.over_id, c.ball_id, c.innings_no)

       inner join Player e on d.player_out = e.Player_Id

       cross join

       (select @total := 0) params

where d.match_id = 335987

group by d.player_out, d.innings_no

order by d.player_out asc;

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});