For each city, return salary_bill (sum of salaries) and pct_of_total — its share of the company's salary bill as a percentage rounded to 2 decimals.
7 rows with columns city, salary_bill, pct_of_total — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Bengaluru | 690000 | 35.15 |
| 2 | Pune | 253000 | 12.89 |
| 3 | Mumbai | 402000 | 20.48 |
Run your code to see the output here.