The white bars on the abdomen are not normally seen on Sphex species, but common on Turneromyia sp. (genus) (Zebra spider wasp). But is not a Turneromyia sp. either.
Looks like the protective capsule of a Case-bearing Leaf Beetle (subfamily Cryptocephalinae); if so, the hole could be where the emerging adult (or a parasite) emerged.
Hi KingParrot, thanks for your sighting. It looks like your sighting contains multiple species. To help us verify each species, please submit each species as a separate sighting. You can edit this sighting and click the duplicate button to make a duplicate of the original sighting.