sunroof ... non motorized, you have to manually open it up and it doesn't completely slide back, it just cracks open. (just like the back windows on a minivan)
moonroof ... motorized, slides completely open. there are 2 styles, 1 where the glass retracts into the roof of the car. 1 where the glass slides open and hangs over the roof of the car.
sunroofs kinda look ghetto. you get the extra light, but it really doesn't do much .. it just pops open
moonroofs are

... the glass completey slides open and it's just like having a window on the top of your car.