How much did customer 6 consume in total between August and November 2013?
Between August And November 2013 refers to Between 201308 And 201311; First 4 strings of Date represents the year.
SELECT SUM(Consumption) FROM yearmonth WHERE CustomerID = 6 AND Date BETWEEN '201308' AND '201311'