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: For the customer who paid 634.8 in 2012/8/25, what was the consumption decrease rate from Year 2012 to 2013?
Evidence: '2012/8/24' can be represented by '2012-08-24'; Consumption decrease rate = (consumption_2012 - consumption_2013) / consumption_2012

SQL:
SELECT CAST(SUM(IIF(SUBSTR(Date, 1, 4) = '2012', Consumption, 0)) - SUM(IIF(SUBSTR(Date, 1, 4) = '2013', Consumption, 0)) AS FLOAT) / SUM(IIF(SUBSTR(Date, 1, 4) = '2012', Consumption, 0)) FROM yearmonth WHERE CustomerID = ( SELECT T1.CustomerID FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T1.Date = '2012-08-25' AND T1.Price = 634.8 )