By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE exam ( id int)
CREATE TABLE dataset ( id int)
select exam.id as exam_id,
(select count(*) from dataset where dataset.id = exam.id) as n_dataset
from exam
HAVING n_dataset = 0
| exam_id | n_dataset |
|---|