Sampledata looks identical to this and this but this time a different person (school assignment perhaps?).
Couldn't you just clear out emp1, and then run your working sql?