Among the trains that run in the east direction, how many of them have more than 2 long cars?
more than 2 long cars refers to longCarsNum > 2
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'
database name:db_id trains
cars table cars Cols: id dtype integer, train id dtype integer, position dtype integer, shape dtype text, length dtype text, sides dtype text, roof dtype text, wheels dtype integer, load_shape dtype text, load number dtype integer, 
trains table trains Cols: id dtype integer, direction dtype text, 
