← Intuit questions
CodingReported in a candidate post, Nov 2021

Compute CTR by score bin from scores and interactions tables

Filed under Intuit

Given a scores table (user_id, score from 0 to 400) and an interactions table (user_id, offer_id, views, clicks), write SQL that returns click-through rate, clicks divided by views, for the score bins…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Intuit questions

Collected from public candidate posts and coding forums. Updated Nov 2026.