By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table employees (
id int,
first_name varchar(20),
office_id int
);
insert into employees values
(1, 'stan', 2),
(2, 'Danny', 1),
(3, 'Elle', 2);
-- https://stackoverflow.com/questions/75326194/counting-the-least-repeated-value-and-printing-the-name-of-that-person
Records: 3 Duplicates: 0 Warnings: 0
with cte as (
SELECT office_id
FROM employees
GROUP BY office_id
order by count(1) asc
limit 1
)
select e.* from cte c
inner join employees e on e.office_id = c.office_id
| id | first_name | office_id |
|---|---|---|
| 2 | Danny | 1 |