Stone Temple Pilots, fronted by the late Scott Weiland, released “Sour Girl” in 1999. The intro (through 0:19) emphasizes G major as a key area, although it also features a flat 7th. The verse (0:19 – 0:56) flips quickly back and forth from D major to D minor (an F# is featured on the melody line on the word “sour ” — coupled with the restless bassline, often suggesting D minor as it shifts as often as every eighth note — adds to the ambiguity).
A far more detailed and scholarly analysis of the tune can be found on the Aaron Krerowicz site.