l AT&T; 3:33 PM @?* 59% ?D. blackboard.ualr.edu C 1 of 1 SQL Exercise 1. List th

Question

l AT&T; 3:33 PM @?* 59% ?D. blackboard.ualr.edu C 1 of 1 SQL Exercise 1. List the names of the employees who work for department 5. For each department, list its department number and the average salary of its employees. For each department, list its department number, name, and the average salary of its employees. Retrieve the names of departments that locate in Houston. Retrieve the names of employees who work on project 2. For each employee that works more than 30 hours on a project, list his/her name along with the corresponding project name and hours. 2. 3. 4. 5. 6.

Explanation / Answer

Query 1 : SELECT Fname, Lname FROM EMPLOYEE, DEPARTMENT WHERE Dnumber=5 AND Dnumber=Dno;

Query 2 :   SELECT dno, avg(salary) from Employee;

Query 3 :   SELECT Fname, Lname , dno, avg(salary) from Employee;

Query 4 :    SELECT Dname from DEPARTMENT , DEPT_LOCATIONS WHERE DEPARTMENT.Dnumber = DEPT_LOCATIONS.Dnumber AND Dlocation='Houston' ;

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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