TikTok Interview Question

Build a complex query, replicate the same query in Python, how would you investigate a drop in KPI.