How to use Case Statement for 2 queries..

Hi Experts,

I have to write Query like,

If 1st Query Then 2nd Query

Else 'NO Result'

NOTE: if 1st query is correct then only 2nd query will execute otherwise go to else,

Both qu