CS 250-01 Homework 3 (100 points, 50 points for each problem. Due day: 03/17/2015)
5.5. Specify the following queries on the COMPANY database in Figure 3.5 in SQL.
For each department whose average employee salary is more than $30,000, retrieve the
I. Give the output of the following SQL query using the data &
tables on page 3.
SELECT EMPLOYEE.SSN, EMPLOYEE.LNAME
FROM DEPARTMENT, EMPLOYEE
WHERE DEPARTMENT.DNAME = 'Administration'
AND EMPLOYEE.DNO = DEPARTMENT.DNUMBER;