This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Credit Risk Analyst at TikTok/ByteDance. The finance team monitors advertiser credit utilization to proactively manage payment risk. They want a report of all advertisers whose total advertising spend exceeds 20% of their credit limit, flagging high-utilization accounts for review. This requires traversing three tables and using multi-level CTEs.
You are a Credit Risk Analyst at TikTok/ByteDance. The finance team monitors advertiser credit utilization to proactively manage payment risk. They want a report of all advertisers whose total advertising spend exceeds 20% of their credit limit, flagging high-utilization accounts for review. This requires traversing three tables and using multi-level CTEs.