You can do state:open linked:pr to see the type 3 (Issues that are resolved but not yet merged) and state:open -linked:pr to see the type 4 (Issues which are open but have no pull requests)
state:open linked:pr
state:open -linked:pr