Make sure those queries are work in SQL SERVER

Q-21. Write An SQL Query To Fetch The Count Of Employees Working In The Department Admin. Ans.

The required query is:

SELECT COUNT FROM worker WHERE DEPARTMENT = 'Admin';

Q-22. Write An SQL Query To Fetch Worker Names With Salaries >= 50000 And <= 100000. Ans.

The required query is:

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);

Q-23. Write An SQL Query To Fetch The No. Of Workers For Each Department In The Descending Order. Ans.

The required query is:

SELECT DEPARTMENT, count(WORKER_ID) No_Of_Workers FROM worker GROUP BY DEPARTMENT ORDER BY No_Of_Workers DESC;

Q-24. Write An SQL Query To Print Details Of The Workers Who Are Also Managers. Ans.

The required query is:

SELECT DISTINCT W.FIRST_NAME, T.WORKER_TITLE FROM Worker W INNER JOIN Title T ON W.WORKER_ID = T.WORKER_REF_ID AND T.WORKER_TITLE in ('Manager');