Assignment about What is SQL Queries?

Running head: HOMEWORK 2
HOMEWORK 2
Name of the Student
Name of the University
Author Note

HOMEWORK 2
1
SQL Queries
1. select e.firstname, e.lastname, e.address from employees e inner join
department d on d.deptnumber=e.deptnumber and d.deptname='Research';
2. select p.projectnumber, d.deptnumber, e.lastname, e.address , e.DOB from
project p inner join department d on d.deptnumber=p.deptnumber inner join
employees e on e.deptnumber=d.deptnumber where e.role='Manager';
3. select firstname, lastname from employees where deptnumber=5;