Assignment 2
Due March 1

All submissions must be in text format, without unicode. 
In particular, standard ASCII quotation marks ' and " must be used (if needed)

E&N exercises 5.5, 5.6, 5.7, 5.8

==============================

5.5: Specify the following queries on the [OFFICE] database. Show the query results 
if each query is applied to the database in Fig 3.6

(a) For each department whose average employee salary is more than $30,000, retrieve
the department name and the number of employees working for that department.

(b) Suppose we want the number of _male_ empoyees in each department making more than
$30,000, rather than all employees as in part (a). Can we specify this query in SQL?
Why or why not? If we can, then give the query.

==============================

5.6: Specify the following queries in SQL on the database schema in Fig 1.2 (student).

(a) Retrieve the names and major departments of all straight-A students (students 
who have a grade of A in all their courses).

(b) Retrieve the names and major departments of all students who do not have a grade
of A in any of their courses.

==============================

5.7: In SQL, specify the following queries on the database in Fig 3.5 (OFFICE),
using the concept of nested queries and concepts described in this chapter.

(a) Retrieve the names of all employees who work in the department that has the
employee with the highest salary among all employees.

(b) Retrieve the names of all employees whose supervisor's supervisor has 
888-66-5555 for ssn.

(c) Retrieve the names of employees who make at least $10,000 mre than the employee
who is paid the least in the company.

==============================

5.8: Specify the following views in SQL on the COMPANY [OFFICE] database schema 
of Fig 3.5:

(a) A view that has the dept name, manager name, and manager salary for each dept

(b) A view that has the employee name, supervisor name, and employee salary for each employee who works in the 'Research' department.

(c). A view tha thas the project name, controlling department name, number of
employees, and total hours worked per week on the project for each project.

(d). A view that has the project name, controlling department name, number of
employees, and the total hours worked per week on the project for each project 
**with more than one empoyee working on it.**