I answered a QotD correctly and I didn't guess! I am pretty new to SQL development (~6months) but I could see straight away there was an issue with the two IDENTITY.

These questions are really helping me improve, keep up the good work.