Select only those records that have one relationship?

Question

SQL

There are two tables "employees" and "departments" which have a many-to-many relationship through an intermediate table. I need to get those departments to which only one employee is attached. I can't figure out how to check that an employee of a given department is attached only to him without sorting through the departments of each employee. Interested in an example of a request that will help get an employee tied only to the requested department.

Answer 1

Make join tables of departments with an intermediate table, group by department and filter by count.

Answer 2

Use the form styler and don't waste your time. Redefining plugin styles is as easy as shelling pears, including the way you have.