Anyone NOT spot after sex?

L

I’m 6 weeks and my husband wants to have sex but I’m very afraid of spotting after and being freaked out about miscarriage.

Anyone not spot after sex? How common is it? I had a vaginal ultrasound and no spotting after that so maybe I’m a lucky one?