Make sure those queries can work in sql server

Q-39. Write An SQL Query To Fetch The First 50% Records From A Table. Ans.

The required query is:

SELECT * FROM WORKER WHERE WORKER_ID <= (SELECT count(WORKER_ID)/2 from Worker);

Q-40. Write An SQL Query To Fetch The Departments That Have Less Than Five People In It. Ans.

The required query is:

SELECT DEPARTMENT, COUNT(WORKER_ID) as 'Number of Workers' FROM Worker GROUP BY DEPARTMENT HAVING COUNT(WORKER_ID) < 5;

Q-41. Write An SQL Query To Show All Departments Along With The Number Of People In There. Ans.

The following query returns the expected result:

SELECT DEPARTMENT, COUNT(DEPARTMENT) as 'Number of Workers' FROM Worker GROUP BY DEPARTMENT;

Q-42. Write An SQL Query To Show The Last Record From A Table. Ans.

The following query will return the last record from the Worker table:

Select * from Worker where WORKER_ID = (SELECT max(WORKER_ID) from Worker);

Q-43. Write An SQL Query To Fetch The First Row Of A Table. Ans.

The required query is:

Select * from Worker where WORKER_ID = (SELECT min(WORKER_ID) from Worker);