By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
inventory_id |
---|
3049 |
(1525) not in ( select inventory_id from rental where return_date is null ) |
---|
1 |
(3049) not in ( select inventory_id from rental where return_date is null ) |
---|
0 |
(9999) not in ( select inventory_id from rental where return_date is null ) |
---|
1 |
inventory_id |
---|
3049 |
inventory_id | i.inventory_id is null |
---|---|
1525 | 1 |
3049 | 0 |
9999 | 1 |