Database schema:

CREATE TABLE customers (
	"CustomerID" INTEGER NOT NULL -- example: ['5', '3'],
	"Segment" TEXT -- client segment, example: ['LAM', 'SME'],
	"Currency" TEXT -- example: ['CZK', 'EUR'],
	PRIMARY KEY ("CustomerID"), 
	UNIQUE ("CustomerID")
)


CREATE TABLE gasstations (
	"GasStationID" INTEGER NOT NULL -- Gas Station ID, example: ['45', '44'],
	"ChainID" INTEGER -- Chain ID, example: ['6', '13'],
	"Country" TEXT -- example: ['CZE', 'SVK'],
	"Segment" TEXT -- chain segment, example: ['Value for money', 'Premium'],
	PRIMARY KEY ("GasStationID"), 
	UNIQUE ("GasStationID")
)


CREATE TABLE products (
	"ProductID" INTEGER NOT NULL -- Product ID, example: ['2', '1'],
	"Description" TEXT -- example: ['Rucní zadání', 'Nafta'],
	PRIMARY KEY ("ProductID"), 
	UNIQUE ("ProductID")
)


CREATE TABLE transactions_1k (
	"TransactionID" INTEGER -- Transaction ID, example: ['2', '1'],
	"Date" DATE -- example: ['2012-08-24', '2012-08-23'],
	"Time" TEXT -- example: ['09:41:00', '10:03:00'],
	"CustomerID" INTEGER -- Customer ID, example: ['31543', '46707'],
	"CardID" INTEGER -- Card ID, example: ['486621', '550134'],
	"GasStationID" INTEGER -- Gas Station ID, example: ['3704', '656'],
	"ProductID" INTEGER -- Product ID, example: ['2', '23'],
	"Amount" INTEGER -- example: ['28', '18'],
	"Price" REAL -- example: ['672.64', '430.72'],
	PRIMARY KEY ("TransactionID")
)


CREATE TABLE yearmonth (
	"CustomerID" INTEGER NOT NULL -- Customer ID, example: ['39', '63'],
	"Date" TEXT NOT NULL -- example: ['201201', '201112'],
	"Consumption" REAL -- example: ['1598.28', '528.3'],
	PRIMARY KEY ("Date", "CustomerID"), 
	CONSTRAINT fk_yearmonth_customers FOREIGN KEY("CustomerID") REFERENCES customers ("CustomerID")
)

Question: What is the highest monthly consumption in the year 2012?
Evidence: The first 4 strings of the Date values in the yearmonth table can represent year; The 5th and 6th string of the date can refer to month.

SQL:
SELECT SUM(Consumption) FROM yearmonth WHERE SUBSTR(Date, 1, 4) = '2012' GROUP BY SUBSTR(Date, 5, 2) ORDER BY SUM(Consumption) DESC LIMIT 1