True.. in the latter seasons Dr lee was shown more as a bumbling fool to imo make carter more impressive.
(I know it doesn't really fit to the post, but I've wanted to use this smiley since I saw it five minutes ago.)
All of the 'scientists' on the show are apparently multidisciplinary. Even Daniel Jackson's range of knowledge is absurdly broad by real world academic standards. McKay is an engineer, and Carter and Lee probably are as well. Presumably there are gobs of off-stage engineers that worked on the F-302 and Prometheus projects though.
Daniel Jackson is a modern renaissance man. Most people in the academic world specialize in one or two subjects, so you'll occasionally get someone with two Ph.D. degrees, although that's quite rare. Some people with the funds for it do rack up lots of Master's degrees, though. I think the confirmed record is 19.