Answers for "Write an SQL query to fetch worker names with salaries >= 50000 and <= 100000."

0

Write an SQL query to fetch worker names with salaries >= 50000 and <= 100000.

SELECT CONCAT(FIRST_NAME, ' ', LAST_NAME) As Worker_Name, Salary
FROM worker 
WHERE WORKER_ID IN 
(SELECT WORKER_ID FROM worker 
WHERE Salary BETWEEN 50000 AND 100000);
Posted by: Guest on July-26-2021

Browse Popular Code Answers by Language