SQL Practice Logo

SQLPractice Online

Company SQL Question

Revenue Contribution %

Practice this Google style SQL interview question with live execution and instant feedback.

Problem Statement

Calculate each user's revenue as a % of total using a scalar subquery as the denominator.

Relevant Tables

ad_clicks

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: