Who’s is a contraction for who is or who has.

Whose is a possessive form of who that’s used as an adjective.

Examples:
Who’s (who is) going to the concert?
Who’s (who has) been to this venue before?

Whose car are we taking?
I wonder whose coat this is.