Just to check whether I understand correctly the stuff from here: Database schema documentation for the public data dump and SEDE.

PostsWithDeleted also contains ClosedDate - so even for deleted questions I can check whether or not they were closed.

But to learn more about the close reason (for example whether it was duplicate, off-topic, ...) I'd have to look in the PostHistory table - and this is available only for posts which are not deleted.

So I can find out whether or not deleted post was closed, but I can't find out from SEDE the close reason. Is that correct?