JOIN or SUBQUERY Question

I don’t fully understand the USE KEYS Am i missing something ?