Answer the Problem 1 using SQL.
Problem 1
Using the commands SELECT, PROJECT, and JOIN, write sequences to answer the following questions about the information in the EMPLOYEE, JOB, and ASSIGNMENT relations in Figure 9.5:
a. Obtain a list of the names and addresses of the company’s employees.
b. Obtain a list of the names and addresses of those who have worked or are working in the personnel department.
c. Obtain a list of the names and addresses of those who are working in the personnel department.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.