Given the following relational database schema:

Employee=(ID, name, position, officeN, phoneN,age)// assume thename is unique.

Committee =( title, meetingDate, startTime, endTime, location)// You may use <,>,=,!= between dates and times.

Membership= ( ID, title, task) // task = member or chair.

Use a minimum number of operations and tables to express the following queries by SQL statements:

1. List the name of every employee who is a chair of at least two committees.

Select name From dis)

2. List the name of every employee who is not serving on any committee.

Employee=(ID, name, position, officeN, phoneN, age)//assume thename is unique.

Committee =( title, meetingDate, startTime, endTime, location)// You may use <,>,=,!= between dates and times.

Membership= ( ID, title, task) // task = member or chair

3. List the name of every employee and the tile of the every committee he or she is serving on as a member ordered by the name of employee.

4. List the name of every employee who is serving aon committee that meet in location starts with the letter S and ends with the integer 7.

Employee=(ID, name, position, officeN, phoneN,age)// assume thename is unique.

Committee =( title, meetingDate, startTime, endTime, location)// You may use <,>,=,!= between dates and times.

Membership= ( ID, title, task) // task = member or chair

5. List the name of every employee who does not have a phone number.

6. List the title of every committee on which both Sandy Liu and Barry Smith are serving.

Employee=(ID, name, position, officeN, phoneN,age)// assume thename is unique.

Committee =( title, meetingDate, startTime, endTime, location)// You may use <,>,=,!= between dates and times.

Membership= ( ID, title, task) // task = member or chair

7. List the title of every committee on which Sandy Liu or Barry Smith is serving.

8. List the name and position of oldest employees.

Employee= (ID, name, position, officeN, phoneN,age)// assume thename is unique.

Committee = ( title, meetingDate, startTime, endTime, location)// You may use

<,>,=,!= between dates and times.

Membership= ( ID, title, task) // task = member or chair

9. List the titles of every two committees which do not meet on the same date.

10. List the name and position of every employee who does have phone number.