Each project is managed by one professor. And each project is worked on by one or more professors. but professors can manage and/or work on multiple projects. Each project is worked on by one or more...

• Each project is managed by one professor. And each project is worked on by one or more professors. but professors can manage and/or work on multiple projects.

• Each project is worked on by one or more graduate students. When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a supervisor for each one.

• Departments have a professor who runs the department. professors work in one or more departments, and for each department that they work in, a time percentage is associated with their job.


• Graduate students have one major department. Each graduate student has another, more senior graduate student who advises him or her on what courses to take(advisor).

Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and average degrees

Departments have a department number, a department name, and a main office.

1. Write Queries for the following:


2. Find the number of graduate students who have the same average degrees, average degrees and display new column as average_degrees*average_degrees/2 for each graduate student, and list in the order of age.