Please help write the problems below in SQL using the relationships and tables b

Question

Please help write the problems below in SQL using the relationships and tables below:

Projects V ProjectID ProjectName ProjectAssignments EmployeeID ojectID Customers customerID -1 firstname ast name Street1 Street2 City Employees EmployeeID Firstname Lastname Department JobClass SupervisorID Start Date EndDate Pay Rate Pay Type Pay Account Hours PostedThisWeek AccruedSickLeave Taken SickLeave Orders order Number CustomerID OrderDateTime PaymentType Amount Departments Department Accounts V Account Number Title ContractNumbe Begin Date Sales Contacts Contact ID Firstname Last name Street1 Street2 City State Zip

Explanation / Answer

1.select * from Employees e,projectassigment p where e.empid =(+)p.empid

+ means left outer join operator

or

select * from Employees e,projectassigment p where e.empid not in(select empid projectassigment )

2.select * from employee where lastname like %___%

3.select count(*) from employee e,Departments d where e.sal>=(select avg(sal) from emp) group by dept

4select min(age),max(age) from empoyees

5select deptno as Deptnumber,job as job,sick leaves as leaves from department,empoyees

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---