Database diagram used
In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used.
Run just portions of the query, mark the section and execute:
docs microsoft sql server
INNER JOIN (Get all that matches on both tables)
SELF JOIN, related to get the manger
Right-click on the specific table name and choose Design option
Right-click on the window->properties
And we are there (after the change, save solution and disconnect-connect.