select e.firstname, e.lastname, sum(o.itemstotal) sales, cast(200*sum(o.itemstotal)/(select sum(itemstotal) from orders ) as integer) percent from customer c join orders o on o.custno=c.custno join employee e on e.empno=o.empno group by 1, 2 order by 4 desc