select date_done, sum(case when replace(description,' ','_') = 'Pull_Up' then act_count else 0 end) as Pull_Up_count, sum(case when replace(description,' ','_') = 'Crunch' then act_count else 0 end) as Crunch_count, sum(case when replace(description,' ','_') = 'Push_Up' then act_count else 0 end) as Push_Up_count, sum(case when replace(description,' ','_') = 'Plank_Time' then act_count else 0 end) as Plank_Time_count, sum(case when replace(description,' ','_') = 'Dumbbells' then act_count else 0 end) as Dumbbells_count, sum(case when replace(description,' ','_') = 'Box_Jump' then act_count else 0 end) as Box_Jump_count from KEBOOLA_7127.WORKSPACE_15661914.V_EXERCISE_STAR group by 1