select * from image im where im.sr_key in ( select sr.sr_key from series sr where sr.st_key in ( select st_key from study where patientid =’L0124243′ ) ) /*image */ delete from image…