The driver side window, which is electric powered, had given me some problems by not moving occasionally, then I rolled it down and remembered that it might now roll back up and as I was trying to move it up it gave out on me and is now stuck halfway up. It rolled down the other day randomly but it rarely moves at all. The passenger side window works fine, and just as a note when I say "rolled up or down" I don't mean manually "rolling" the window.
Most likely cause is a bad motor. Give the bottom of the door panel a good whack. Careful if it's cold as you can crack the door panel. This may be enough to jar the brushes in the motor to make it work long enough to get the window up.
Another way to tell if it's the window motor is with the dome light on, watch the light when you push the up or down button on the drivers window. If the light dims when you push the switch it's the window motor.
Ultimately you can take the door panel off, actually may be the door skin that comes off on that model to gain access to the motor itself. Check for power and ground by back probing at the motor while operating the switch.
I just spent quite awhile fixing this exact same problem on my 2002 SC2. I tore down my driver door several times and went through everything but it turned out to be the window switch on the center console. The tiny metal contacts inside had gotten dirty and were very worn and would only sometimes make an electrical connection. Unfortunately this is an electronic part and not a simple electrical part so it's more expensive to replace. Be very careful if you take the switch apart to clean it as the small spring-loaded pieces can go flying and each switch has a thin plastic piece that's easy to break.