should see a message with BOTH of your names ============ lab query 1 ============ EMPL_LAST_NAME HIREDATE --------------- --------- Jones 02-APR-12 Blake 01-MAY-13 ============ lab query 2 ============ HIREDATE --------- 17-NOV-11 09-JUN-12 23-JAN-16 ============ lab query 3 ============ EMPL_LAST_NAME HIREDATE --------------- --------- Michaels 20-FEB-18 Ward 22-FEB-19 Martin 28-SEP-18 Scott 09-NOV-18 Turner 08-SEP-19 Adams 23-SEP-18 James 03-DEC-17 Miller 23-JAN-16 8 rows selected. ============ lab query 4 ============ Employee Department (Location) --------------- --------------------------------- King Management (New York) Jones Research (Dallas) Blake Sales (Chicago) Raimi Accounting (New York) Ford Research (Dallas) Smith Research (Dallas) Michaels Sales (Chicago) Ward Sales (Chicago) Martin Sales (Chicago) Scott Research (Dallas) Turner Sales (Chicago) Employee Department (Location) --------------- --------------------------------- Adams Operations (Boston) James Sales (Chicago) Miller Accounting (New York) 14 rows selected. ============ lab query 5 ============ DEPT_NAME --------------- Research Management ============ lab query 6 ============ EMPL_LAST_NAME --------------- Ward Turner ============ lab query 7 ============ EMPL_LAST_NAME JOB_TITLE HIREDATE --------------- ---------- --------- Adams Clerk 23-SEP-18 Ford Analyst 03-DEC-12 Jones Manager 02-APR-12 Martin Sales 28-SEP-18 Michaels Sales 20-FEB-18 Scott Analyst 09-NOV-18 Smith Clerk 17-DEC-12 Turner Sales 08-SEP-19 Ward Sales 22-FEB-19 9 rows selected. ============ lab query 8 ============ Enter value for department_name: 'Research' old 4: and dept_name = &department_name new 4: and dept_name = 'Research' EMPL_LAST_NAME JOB_TITLE --------------- ---------- Jones Manager Ford Analyst Smith Clerk Scott Analyst =========== lab part 9 =========== This should print an example question you could ask about employees, departments, and/or customers that you think you can answer using one or more of: nested select/sub-select, concatenation, union, interactive input For example: What are the names of employees hired after the latest-hired manager? (and here you should see the result of your query answering that question) For example: EMPL_LAST_NAME --------------- Michaels Ward Martin Scott Turner Adams James Miller 8 rows selected.