Game Play Analysis III

Given a gameplay events table recording player, level, and result, write an SQL query to identify players with failure/success patterns (e.g., players who failed at least one level or who failed then later passed). The core challenge is grouping and comparing per-player/per-level outcomes using aggregation, set-difference/anti-joins or window functions to isolate the required cases.