Employee Salary and Insurance Details

Problem Statement

Problem Description Write an SQL query to retrieve the salary and insurance details for all employees, along with their respective job categories. Schema Table: EMPLOYEE_INFO employee_id (INT): The unique identifier for the employee. employee_category (VARCHAR): The job category or role of the employee (e.g., 'Manager', 'Developer'). Table: SALARY_INFO employee_id (INT): The unique identifier for the employee (Foreign Key referencing EMPLOYEE_INFO.employee_id ). basic (DECIMAL): The basic salary paid to the employee. insurance (DECIMAL): The insurance amount provided by the company. Required Output Your query should return a result set with exactly three columns in the following order, using the exact aliases specified: Employee_Category (retrieved from the employee_category column) Basic (retrieved from the basic column) Insurance (retrieved from the insurance column) Constraints or Notes There is a strict one-to-one relationship between the EMPLOYEE_INFO and SALARY_INFO tables. Every