MySQL query logic

SELECT case
when c.boarding_number is not NULL then 'YES'
else 'NO'
end ;
It's syntactically correct.