Out of every 100 in payroll

Problem

Management wants to see how much of the payroll sits at the top. Out of every 100 the company pays in salaries, how much goes to each person? And how much goes, all together, to everyone who earns as much as that person or more?

Show the name, the salary, that person's share of the whole company's payroll, and the combined share of everyone who earns that salary or more, that person included, in that order. Both shares are percentages, rounded to 1 decimal. Two people with the same salary get the same numbers. Carol has no department, but she gets paid: her salary counts.

Sort from the highest salary to the lowest and, on a tie, by name.

What it has to return

This is what comes out with the data in the practice database this challenge uses. The column names don’t count, so name yours however you like: what counts is how many there are and the order they come in. Besides this one, the challenge has hidden tests with other data that are revealed when you submit your solution.

You start with this

SELECT name, salary,
  SUM(salary) OVER () AS total
FROM employees
ORDER BY salary DESC, name;