Noncorrelated

SELECT pub_nameFROM publishersWHERE pub_id in (SELECT pub_id FROM titles WHERE type=‘business’)

Subquery executes once and returns a list of values with which the outer query uses to finish its execution and evaluation