Lesson 1 - Night scene. Involves heavy photobashing, paint overs, gradient use and texture do-overs.
The original render is included for reference. It wasn't very close to the finished image, but hey, that's what Photoshop and a bit of imagination is for!
Some of the side silhouettes didn't make it into the final shot or were omitted entirely.