Found in 1 comment on Hacker News
I swear by O'Reilly's SQL Cookbook ( The examples start of easy and get more complicated as you go along, all with detailed explanations. The book is a bit out of date but it's still useful. IMHO, it will turn you from a novice to an intermediate in no time.

Fresh book recommendations delivered straight to your inbox every Thursday.