Results 1 issues of Lester

Hi, sorry but I'm somehow confused on how to exactly do query condition for IF and IS NULL I have this particular SQL query but not sure how to convert...