The SUM(CASE WHEN pattern in SQL to compute valued columns

Thanks

This really helped me thanks

It helped. Thanks Jeffrey

This video is the Jewel for me. I was searching everywhere. It really solved my real life problem. Thank you so much for this wonderful video. Please keep producing such interesting analytical videos. All the best!

HEllo Jeffrey - I am trying to add another SUM((
case
when `Offer Accepted` in ('Yes') then 1
else 0
end
))


I need to pull data for other column to add the same then to '1'.

Great, thanks!

I can barely see the screen