Top 9 SQL queries for interview | SQL Tutorial | Interview Question
FAQ
How to write an SQL query to fetch workers names with salaries >= 50000 and 100000?
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);
