SQL · Rippling · Easy
Problem Write a SQL query over a business fact table that first summarizes rows by a chosen dimension with an aggregate such as COUNT or SUM. Then calculate the percentage represented by each group by comparing its aggregate value with the required total, which may be a global total or a total after applying a filter. The exact table schema, grouping column, aggregate, and denominator will be supplied by the interviewer or established during the discussion. Expected Format…
Checking your access…