1. Show all the data from DEPARTTMENT table and order by DepartmentName. Save the query as qry_DEPT.
2. Show all the data from EMPLOYEE table and order by DepartmentName. Save the query as qry_EMP.
3. Show all the data from PROJECT table and order by DepartmentName. Save the query as qry_PROJ.
4. Show all the data from ASSIGNMENT table and order first by ProjectID, and then by EmployeeNumber. Save the query as qry_ASGN,
5. What are the ProjectID, ProjectName, StartDate, and EndDate values of projects in the PROJECT table? Save the query as qry_PROJ_DATE
6. Show the employees’s EmployeeNumber, FirstName, LastName, Position, OfficePhone, and EmailAddress for those who work in the InfoSystems department. Save the query as qry_EMP_IS
7. Show all the data for project which are completed within June 2017 (the EndDate falls in June 2017). Save the query as qry_PROJ_JUNE2017
No More Worries!
Our orders are delivered strictly on time without delay
No Lateness!
Our orders are delivered strictly on time without delay AEW Guarantees
- Free Unlimited revisions
- Guaranteed Privacy
- Money Return guarantee
- Plagiarism Free Writing
Our Services
- Research Paper Writing
- Essay Writing
- Dissertation Writing
- Thesis Writing
Why Choose Us
- Money Return guarantee
- Guaranteed Privacy
- Written by Professionals
- Paper Written from Scratch
- Timely Deliveries
- Free Amendments