NRQL queries to find only open incidents now

Hello Team,

How to do join or filter with the output of other queries in NRQL,
I would like to build a query which will give me the current open incident list.