Questions 9-11 on Microsoft Access Customers V CustomerID firstname ast name Str

Question

Questions 9-11 on Microsoft Access

Customers V CustomerID firstname ast name Street1 Street 2 City State Country Zipcode Departments Department Accounts AccountNumber Title ContractNumbe BeginDate Orders orderNumber CustomerID OrderDateTime Payment ype Amount Employees EmployeeID Firstname Lastname Department JobClass Supe StartDate EndDate Pay Rate PayT Pay Account Hours PostedTh Wee AccruedSickLeave TakensickLeave LastPerformanceRatin Gender Age Projects 8 ProjectID Project Name ProjectAssignments EmployeeID ProjectID Sales Contacts Contact ID Firstname Lastname Street1 Street2 City State Zip

Explanation / Answer

1)select A.EmployeeID from Employees A where A.EmployeeID NOT IN(select B.EmployeeID from ProjectAssignments B where   B.EmployeeID=A.EmployeeID);
2)select A.Lastname from Employees A Group By A.Lastname having COUNT(A.Lastname) > 2;
3)Salary column name does not exist in any of the tables above

4)select A.* from Employees A where A.Age between :1 and :2;
(in this query instead of MIN and MAX used between, and which fetch the same desired result)

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.