Consider the two schemas employees (id, first_name, last_name, designation, joining_date, salary, dept_id) and department (dept_id, dept_name)…
Consider the two schemas employees (id, first_name, last_name, designation, joining_date, salary, dept_id) and department (dept_id, dept_name), where dept_id is a foreign key. Find the first_name and department name of the employee whose salary is maximum.
From the BIWTA Assistant Engineer (CSE) February 2023 – Written (BUET) exam, question 5 of 9.