You have a clicks table and an impressions table, both keyed by user_id and timestamp. Write a query returning click-through rate per ad campaign over a given date range.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

You have a clicks table and an impressions table, both keyed by user_id and timestamp. Write a query returning click-through rate per ad campaign over a given date range.

Practice more