Problem
Given a table of user ad impressions and another table of ad clicks, write a query to calculate the click-through rate (CTR) per advertiser for the last 30 days.
Practicing as: Financial Analyst interview at PinterestHi, I'll play your Pinterest interviewer for the Financial Analyst role. Candidates describe these interviews as mixed and moderately difficult, so expect me to be professional and fair. Take your time with the question above and answer like we're in the room.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
