SQL Aggregation and Percentage Calculation

You are given a business fact table (exact schema not fixed in the post). You need to:

  1. Aggregate the data by a specified dimension using an aggregate function (e.g., COUNT, SUM).
  2. Based on t...

Unlock to view complete problem details

and practice with sample input/output

Was this article helpful?

View Test Cases & Run Code requires membership

Standard Input
Execution Result: