Consider the five tables dept, emp, designation, compensation, and emp_dept as shown in the following ER Diagram.

The employer wants to know the second-highest salary paid to the employee in the month of January 2021.

Can you help with a query to get emp_no, first_name, last_name, gender, dept_no, dept_name, and the salary credited in January 2021.

Note: Table Names and column names should be in the same case (lower/uppercase/InitCap) given in question while writing SQL queries else it will create a syntax error.

Expected Output Format Based on the sample output provided in the images, the result set should look like this (comma-separated if it were raw CSV, but standard columns for SQL):