SQL Code for Employee Information

Hi,

May I kindly request an SQL query that will provide the employees' information with their supervisor and their total vacation and sick leave balance based on the effective date?

Sample Output:

Full Name: Mr. Juan Dela Cruz (Dela Cruz, Mr. Juan)

Position: Junior ICT Assistant

Organization: UP Information Technology Development Center (remove UPS)

Location: Diliman

Effective Date of Leave Balance: Ex. 01-FEB-2023

Vacation Leave Balance: 1.25

Sick Leave Balance: 1.25

Employee Supervisor: Prof. Paulo Noel G. Paje (Paje, Prof. Paulo Noel Gacias)

Supervisor Position: Director II

Supervisor Organization: Office of the Vice President for Development (remove UPS)

Please see the screenshot below for your reference