1-

SELECT *

FROM Employee

ORDER BY lName, fName

2-

SELECT *

FROM Employee

WHERE sex = ‘feminino’

3-

SELECT fName, lName, address

FROM Employee as E

INNER JOIN Department as D

ON E.empNo = D.mgrEmpNo

4-

SELECT fName, lName, address

FROM Employee as E

NATURAL JOIN Department as D

WHERE D.deptName = 'IT'

5-

SELECT fName, lName

FROM Employee as E

NATURAL JOIN WorksOn as W

JOIN Project as P

ON W.projNo = P.projNo

WHERE P.projName = 'SCCS'

6-

SELECT *

FROM Employee as E

JOIN Department as D

ON E.empNo = D.mgrEmpNo

WHERE

E.DOB <= date('1955-12-31')

ORDER BY lName

7-

SELECT COUNT(empNo) as Total

FROM Employee

JOIN Department as D

ON D.mgrEmpNo = Employee.empNo

AND  Employee.fName = 'James' and Employee.lName = 'Adam';

8-

SELECT Employee.empNo, SUM(hoursWorked) AS Hours_Worked

FROM Employee

JOIN Department

ON Employee.deptNo = Department.deptNo

JOIN WorksOn

ON Employee.empNo = WorksOn.empNo

GROUP BY Employee.empNo

ORDER BY Department.deptName, Employee.lName

9-

SELECT projName, projNo, count(empNo) as numEmpregados

FROM Project as P

JOIN WorksOn as W

ON p.projNo = W.projNo

GROUP BY W.projNo

HAVING numEmpregados>2

10-

SELECT deptNo, count(empNo) as TOTAL_EMPREGADOS

FROM Employee

GROUP BY deptNo

HAVING TOTAL_EMPREGADOS>10