I have a table of positions and a table of employees. In the employees
table is a position number which corresponds to the position number in the
positions table. Up to 2 employees can have the same position number. Is
there a slick way in SQL to count the number of positions which do not have
an employee assigned?
Vacant positions = 1 (position_number 4)
Any suggestions or references will be greatly appreciated!!