There is a ...
Terms and Conditions
There is a table (employee), which has a column with an identity of a department (department_id). Select list of departments where the count of employees less than 3.
select department_id from employee group by department_id having count(*) <= 3
select department_id from employee where count(department_id) <= 3
select department_id from employee where max(*) <= 3
Get an explanation when it's available:
Login to learn SQL
Read more about
Sign Up Now
Subscribe for future quizzes