Write the SQL Code based on the tables

Name of employees in alphabetical order.

Name of employees, name of their corresponding departments and name of their corresponding branches.

The Department name and the sum of salary of all employees in the respective department.

Sum of Salary of All Employees

Sum of Salary by Department

Give a 10% raise to all Employees

Remove all employees located in Palo Alto

BRANCH bid B01 B02 bname Olympia Seattle EMPLOYEES Sala eid Ename E1 Bill Gates E2 Steve Jobs E3 Ted Codo E4 Michael Ci Redmond 90 Palo Alto 80 New York 70 Berkeley 60 didmi