From the following table, write a SQL query to find those employees who have completed their previous jobs. Return employee ID, end_date.
Sample table : job_history
+-------------+------------+------------+------------+---------------+
| EMPLOYEE_ID | START_DATE | END_DATE | JOB_ID | DEPARTMENT_ID |
+-------------+------------+------------+------------+---------------+
| 102 | 2001-01-13 | 2006-07-24 | IT_PROG | 60 |
| 101 | 1997-09-21 | 2001-10-27 | AC_ACCOUNT | 110 |
| 101 | 2001-10-28 | 2005-03-15 | AC_MGR | 110 |
| 201 | 2004-02-17 | 2007-12-19 | MK_REP | 20 |
| 114 | 2006-03-24 | 2007-12-31 | ST_CLERK | 50 |
| 122 | 2007-01-01 | 2007-12-31 | ST_CLERK | 50 |
| 200 | 1995-09-17 | 2001-06-17 | AD_ASST | 90 |
| 176 | 2006-03-24 | 2006-12-31 | SA_REP | 80 |
| 176 | 2007-01-01 | 2007-12-31 | SA_MAN | 80 |
| 200 | 2002-07-01 | 2006-12-31 | AC_ACCOUNT | 90 |
+-------------+------------+------------+------------+---------------+
Sql programming
Sample Output:
employee_id | max -------------+------------ 101 | 2005-03-15 200 | 2006-12-31 176 | 2007-12-31 (7 rows)need an explanation for this answer? contact us directly to get an explanation for this answer