I found this example on https://sqlbolt.com/topic/subqueries
Isn't the "dept_employees" on the last row of the query should refer to a table? From the row before it shows that it is a column.
I have tried to run it on MySQL and got "Error Code: 1054. Unknown column 'dept_employees.department' in 'where clause'"