zapros

SELECT id_detail
FROM details d
WHERE (EXISTS(SELECT 1 FROM availability_details a where quantity_in_warehouse > 100
and (200 < ALL (Select quantity from shipment_accounting s where d.id_detail = a.id_detail and a.id_detail = s.id_ready_detail and a.num_warehouse = s.num_warehouse))))