SQL: Prime and 3rd Highest Salary

Write a SQL query to find prime numbers and also return the 3rd highest salary.

Use the numbers and employees tables. Treat the third highest salary as the third distinct salary, and return every employee tied at that salary.

Output

1. Return result_type, prime_number, employee_name, and salary.
2. Use one row per prime number and one row per employee at the third highest salary.
3. Sort prime rows in ascending numeric order, followed by the salary rows.

Output details

• Use prime for prime rows and third_highest_salary for salary rows in result_type.
• Return NULL in non-applicable columns for each row type.
• Exclude numbers below 2 and treat duplicate number values as one prime result.
• Exclude employees whose salary is NULL.
• Sort salary rows by employee_name in ascending order.
• Return salaries without rounding or altering their numeric precision.