The outer query compares employee names directly with the word Sales

The expression groups employees and counts each department

The inner query renames every employee's department to Sales

The inner query returns matching department IDs, and the outer query keeps employees whose ID is in that set