RaghuDMT

select season_year,
Fours,
Sixes,
[Country_Name],
sum(fours*4+Sixes*6) as total_runs_in_boundries 
from (SELECT season.season_year,country.Country_Name,
       Sum (CASE 
              WHEN batsman_scored.runs_scored = 4 THEN 1 
              ELSE 0 
            END) AS 'Fours',