SAP HANA SQL

[#1]

Hi experts,

IF the name of NODE N02 is not null (Cherry), then select NAME of N02, it is one row :

Cherry

IF the name of NODE N02 is null(#) , then select NAME of N23 and N24, there are two rows :

Alpha

Tom

How to achieve this using SAP HANA SQL ?

Tks.