SQL Aggregation and Percentage Calculation

You are given a business fact table (exact schema not fixed in the post). You need to: Aggregate the data by a specified dimension using an aggregate function (e.g., COUNT, SUM). Based on the aggregated result, compute a percentage for each group by dividing the group aggregate by a total (global total or a filtered total), and output the percentage. Constraints / format: Solve in SQL. HackerRank whiteboard walkthrough. No test cases are provided. Note: The original post does not include the schema, grouping dimension, or the denominator definition, so the prompt is reconstructed to a generic “aggregate then percentage” task.