Database schema:

CREATE TABLE cars (
	id INTEGER NOT NULL -- example: ['2', '1'],
	train_id INTEGER DEFAULT NULL -- example: ['2', '1'],
	position INTEGER DEFAULT NULL -- example: ['2', '1'],
	shape TEXT DEFAULT NULL -- example: ['rectangle', 'bucket'],
	len TEXT DEFAULT NULL -- example: ['long', 'short'],
	sides TEXT DEFAULT NULL -- example: ['not_double', 'double'],
	roof TEXT DEFAULT NULL -- example: ['none', 'peaked'],
	wheels INTEGER DEFAULT NULL -- example: ['2', '3'],
	load_shape TEXT DEFAULT NULL -- example: ['hexagon', 'circle'],
	load_num INTEGER DEFAULT NULL -- example: ['1', '3'],
	PRIMARY KEY (id), 
	CONSTRAINT fk_cars_trains FOREIGN KEY(train_id) REFERENCES trains (id)
)


CREATE TABLE trains (
	id INTEGER NOT NULL -- example: ['2', '1'],
	direction TEXT DEFAULT NULL -- example: ['west', 'east'],
	PRIMARY KEY (id)
)

Question: Among the trains that run in the east direction, how many of them have more than 2 long cars?
Evidence: more than 2 long cars refers to longCarsNum > 2

SQL:
SELECT SUM(CASE WHEN T2.longCarsNum > 2 THEN 1 ELSE 0 END)as count FROM trains AS T1 INNER JOIN ( SELECT train_id, COUNT(id) AS longCarsNum FROM cars WHERE len = 'long' GROUP BY train_id ) AS T2 ON T1.id = T2.train_id WHERE T1.direction = 'west'