كيف أعمل هذا الاستعلام

isa ely 2a2olhalak yetla3 sa7

ha3milak massal we anty 3alek tefhao 3ala 2ad mate2dar

2anty 3adnak maslan 3 Location

فرع بالرياض وجده والخبر

KOl wa7ed lhe location_id

selec * from [ Main Data ] Where Location_id =

(

select location_id, Max(employee_count) from

(

select count(employee_id) as employee_count,location_id from Table group by location_id

) group by location_id

)

شكرا :)