BRANCH bname Olympla Seattle EMPLOYEES bid B01 B02 eid Ename E1 Bill Gates Cit R

Question

BRANCH bname Olympla Seattle EMPLOYEES bid B01 B02 eid Ename E1 Bill Gates Cit Redmond90 Palo Alto 80 New York 70 Berkeley60 Salarydid mid E2Steve Jobs E3 Ted Codd E4 Michael D1 null D2 null D2 E2 D2 | E3 DEPARTMENTS Did D1 D2 D4 Dname Engineerin Securit Marketing bid B01 B02 B01 Stonebreaker E5 Alan Ka E6 Adelle Palo Alto 60 San Jose 60 D1 E1 D2 D2 Goldber Write the SQL Code based on the tables above 11) Name of employees in alphabetical order 12) Name of employees, name of their corresponding departments and name of their corresponding branches 13) The Department name and the sum of salary of all employees in the respective department 14) Sum of Salary of All Employees 15) Sum of Salary by Department 16) Give a 10% raise to all Employees 17) Remove all employees located in Palo Alto

Explanation / Answer

As per Chegg policy, I am answering only first question. Kindly upload remaining questions further in order to get them answered.

11.) Order by sorts the list in ascending order. Default sorting order is ascending, in case of sorting in descending order, we need to write like this order by [col_name] Desc;

Now, SQL query for listing name of employees in alphabetical order will be:

Select Ename from Employees

Order by Ename;

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.