create a query that shows the last name first name date hired and state for employee 5150746
Create a query that shows the last name, first name, date hired, and state for employees who live in Delaware or were hired after 12/31/99. The primary sort (ascending) is on last name, and, the secondary sort ascending is on the first name. The Primary Sort field must be to the left of the Secondary sort field in the query setup.
link to access file https://drive.google.com/open?id=16eEFQdmIeM4Uq5S8eTY3ch3qaGo3IG17
if your name was joseph Brady your output would like this
Practice Query 2 La st Name First Name Dae Hir ed Stae Joseph Jane 9/15/2017 MD 6/1/2017 DE 6/1/1996 DE Brady Howard Johnson John Sue 7/15/2004 DE 7/15/1987 DE Jones Smith Albert FIGURE B-52 Numbor 3 quon I