Spear Thistle

With visitor.

Volucella pellucens, the pellucid fly, or pellucid hoverfly.

One of the UK's larger flies with a white/translucent band across its abdomen.  This one appears to be a female.

As with all hoverflies, it is harmless to humans.