Missing faces after adding Boolean modifier
You should remove the faces and edges in the middle before using the screw modifier. Because or else there will be interior faces in the mesh and it messes up the boolean modifier.