(Solved) : 1 Write Sql Command Create Works Table 2 Write Sql Command Add Attribute Named Dataeofbirt Q37395823 . . .
1. Write an SQL command to create the works-on table.
2. Write an SQL command to add an attribute named DataeOfBirthto the employee table.
3. Write an SQL command to List the name of the employee(s) inthe research department that has the maximum salary in thisdepartment.
4. Write an SQL command to List the name of each employee whodoes not work in any project.
5. Write an SQL command to List the name of each employee andthe total hours he/she has worked in all projects.
6. Write an SQL command to List the name of each department andthe name of its manager.
7. Write an SQL command to Raise the salary of all employeeswhose salary is below the average salary of all employees.
8. Write an SQL command to List the name of each employee whohas at least one son and he is a manager of some department andworks on at least two projects.
9. Write an SQL command to delete all projects that nobody workson them.
10. Write an SQL command to remove all dependents whoseparent(s) are not supervisors.
Expert Answer
Answer to 1 Write Sql Command Create Works Table 2 Write Sql Command Add Attribute Named Dataeofbirt Q37395823 . . .
OR