your names should appear here ============ lab query 1 ============ JOB_TITLE MGR ---------- ---- Clerk 7698 Clerk 7782 Clerk 7788 Clerk 7902 Sales 7698 ============ lab query 2 ============ JOB_TITLE MGR ---------- ---- Sales 7698 ============ lab query 3 ============ JOB_TITLE MGR ---------- ---- Clerk 7698 Clerk 7782 Clerk 7788 Clerk 7902 ============ lab query 4 ============ EMPL_LAST_NAME TWICE_SALARY --------------- ------------ Miller 2600 Adams 2200 James 1900 =============== lab query-set 5 =============== EMPL_LAST_NAME COMMISSION --------------- ---------- Michaels 300 Ward 500 Martin 1400 Turner 0 EMPL_LAST_NAME 0 --------------- ---------- King 0 Jones 0 Blake 0 Raimi 0 Ford 0 Smith 0 Scott 0 Adams 0 James 0 Miller 0 10 rows selected. EMPL_LAST_NAME COMM_VALUE --------------- ---------- Martin 1400 Ward 500 Michaels 300 Adams 0 Blake 0 Ford 0 James 0 Jones 0 King 0 Miller 0 Raimi 0 EMPL_LAST_NAME COMM_VALUE --------------- ---------- Scott 0 Smith 0 Turner 0 14 rows selected. =============== lab query-set 6 =============== EMPL_LAST_NAME JOB_TITLE SALARY --------------- ---------- ---------- King President 5000 Ford Analyst 3000 Scott Analyst 3000 EMPL_LAST_NAME JOB_TITLE SALARY --------------- ---------- ---------- King President 5000 Raimi Manager 2450 Miller Clerk 1300 EMPL_LAST_NAME JOB_TITLE SALARY --------------- ---------- ---------- Miller Clerk 1300 Raimi Manager 2450 Ford Analyst 3000 Scott Analyst 3000 King President 5000 ============= lab problem 7 ============= EMPL_LAST_NAME JOB_TITLE SALARY COMMISSION --------------- ---------- ---------- ---------- Michaels Sales 1600 300 Ward Sales 1250 500 Martin Sales 1250 1400 Turner Sales 1500 0 2 rows updated. EMPL_LAST_NAME JOB_TITLE SALARY COMMISSION --------------- ---------- ---------- ---------- King President 5000 Jones Manager 2975 Blake Manager 2850 Raimi Manager 2450 Ford Analyst 3000 Smith Clerk 800 Michaels Sales 1600 300 Ward Sales 1250 600 Martin Sales 1250 1500 Scott Analyst 3000 Turner Sales 1500 0 EMPL_LAST_NAME JOB_TITLE SALARY COMMISSION --------------- ---------- ---------- ---------- Adams Clerk 1100 James Clerk 950 Miller Clerk 1300 14 rows selected. ============= lab problem 8 ============= 3 rows deleted. EMPL_LAST_NAME JOB_TITLE SALARY --------------- ---------- ---------- King President 5000 Jones Manager 2975 Blake Manager 2850 Raimi Manager 2450 Ford Analyst 3000 Michaels Sales 1600 Ward Sales 1250 Martin Sales 1250 Scott Analyst 3000 Turner Sales 1500 Miller Clerk 1300 11 rows selected. ============= lab problem 9 ============= Rollback complete. 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: union, intersect, minus For example: What are the names, salaries, and commissions of employees whose salary is less than 2000 but also have no value for commission? (and here you should see the result of your query answering that question) For example: EMPL_LAST_NAME SALARY COMMISSION --------------- ---------- ---------- Adams 1100 James 950 Miller 1300 Smith 800