|can somebody help me regaring sql join multiple tables queries?|
Given the following Schema, answer the following queries:
employee(fname, minit, lname, ssn, bdate, address, sex, salary, superssn, dno)
department(dname, dnumber, mgrssn, mgrstartdate)
project(pname, pnumber, plocation, dnum)
works_on(essn, pno, hours)
dependent(essn, dependent_name, sex, bdate, relationship)
7. Retrieve the name and address of all employees who work for the
8. For every project located in 'Stafford', list the project number, the
controlling department number, and the department manager's last name,
address, and birthdate.
9. Find the names of employees who work on all the projects controlled
by department number 5.
10. Make a list of project numbers for projects that involve an employee
whose last name is 'Smith', either as a worker or as a manager of the