The main difference is tha one is considered by the earth facing constantly the sun, while in the other has nothing to do with the sun, the earth is facing a star in the background.
Sidereal day
23.9344 696 hours
I think this shows off the spiral.
Solar day
origin of the solar day 24.0000 hs exactly
every day is 24 solar hours. Solar day = 24 hours and 360.98 degrees of rotation.
summing up
f solar day, the Earth rotates more than 360 degrees for one solar day (24h) and exactly 360 deg for one sidereal day (23:56:4)
WE DO NOT (just)ORBIT THE SUN. we follow the sun follinw the galaxy center.