SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

;WITH  Data AS

(
	SELECT hotelId=1 , departmentId = 'A', workerId = 100
	UNION ALL
	SELECT hotelId=1 , departmentId = 'A', workerId = 101
	UNION ALL
	SELECT hotelId=1 , departmentId = 'A', workerId = 102
	UNION ALL
	SELECT hotelId=1 , departmentId = 'A', workerId = 103
	UNION ALL
	SELECT hotelId=2 , departmentId = 'B' , workerId = 100
	UNION ALL
	SELECT hotelId=2 , departmentId = 'C' , workerId = 100
	UNION ALL
	SELECT hotelId=3 , departmentId = 'D' , workerId = 105
	UNION ALL
	SELECT hotelId=3 , departmentId = 'D' , workerId = 106
	UNION ALL						   
	SELECT hotelId=3 , departmentId = 'D' , workerId = 107
	UNION ALL						   
	SELECT hotelId=3 , departmentId = 'D' , workerId = 108
	UNION ALL
	SELECT hotelId=3 , departmentId = 'E' , workerId = 109
	UNION ALL
	SELECT hotelId=3 , departmentId = 'E' , workerId = 110
	 UNION ALL
	SELECT hotelId=3 , departmentId = 'F' , workerId = 112
	
	
)

select   hotelid,departmentid  , cnt= count(*)   over (partition by hotelid) ,min_cnt = min(count(*))   over (partition by hotelid)   
from data
group by hotelid, departmentid
ORDER BY hotelid

--SELECT * ,  ROW_NUMBER()  OVER (PARTITION BY hotelId,departmentId  ORDER BY hotelId) FROM Data  
--,
--       cte as
--     ( select distinct hotelid,
--           m = min(count(*)) over (partition by hotelid)
--       from data
--       group by hotelid, departmentid
--     )
-- select hotelid
-- from cte
-- where m >= 3 ;

hotelid	departmentid	cnt	min_cnt
1	A	1	4
2	B	2	1
2	C	2	1
3	D	3	1
3	E	3	1
3	F	3	1

Msg 208 Level 16 State 1 Line 1
Invalid object name 'T'.