Question 2 Employee: Source EMP_ID 100 100 101 101 103 103 MGR_ID REP_DT 01/01/2016 06/05/2018 07/10/2018 12/02/2018 06/20/2018 200 201 201 -1 200 06/20/2018 NULL> 200 Please provide a SQL to obtain the below output. Output EMP_ID MGR_ID START 100 100 101 101 END 01/01/2016 06/04/2018 06/05/2018 <NULL> 07/10/2018 12/01/2018 12/02/2018 NULL> 200 201 201 1 Show transcribed image text Question 2 Employee: Source EMP_ID 100 100 101 101 103 103 MGR_ID REP_DT 01/01/2016 06/05/2018 07/10/2018 12/02/2018 06/20/2018 200 201 201 -1 200 06/20/2018 NULL> 200 Please provide a SQL to obtain the below output. Output EMP_ID MGR_ID START 100 100 101 101 END 01/01/2016 06/04/2018 06/05/2018 07/10/2018 12/01/2018 12/02/2018 NULL> 200 201 201 1
Expert Answer
Answer to Question 2 Employee: Source EMP_ID 100 100 101 101 103 103 MGR_ID REP_DT 01/01/2016 06/05/2018 07/10/2018 12/02/2018 06/…