This just another possible way :

Select lt.*

FROM

(Select avatarID, episode From #clients where [status]='add') as lt

Left join

(Select avatarID, episode From #clients where [status]='discharge') as rt

ONlt.avatarID = rt.avatarID

and lt.episode=rt.episode

WHERE rt.avatarID is NULL and rt.episode IS NULL