pg_exercises=# SELECT b.first_name,b.last_name
pg_exercises-# FROM employees b
pg_exercises-# WHERE NOT EXISTS (
pg_exercises(# SELECT 'X'
pg_exercises(# FROM employees a
pg_exercises(# WHERE a.manager_id = b.employee_id);
first_name | last_name
-------------+-------------
Bruce | Ernst
David | Austin
Valli | Pataballa
Diana | Lorentz
Alexander | Khoo
Shelli | Baida
Sigal | Tobias
Guy | Himuro
Karen | Colmenares
Jason | Mallin
Michael | Rogers
Ki | Gee
Hazel | Philtanker
Stephen | Stiles
John | Seo
Joshua | Patel
Trenna | Rajs
Curtis | Davies
Randall | Matos
Peter | Vargas
Janette | King
... | ...
Susan | Mavris
Hermann | Baer
William | Gietz
(88 rows)
Sample table: employees
Output:
need an explanation for this answer? contact us directly to get an explanation for this answer