Table: locomotive_lner
Columns: class
type
quantity
date
lner_class
1946_lner_nos

Question: On what date was the type 2-8-0 with a O4 LNER Class?
SQL: SELECT "date" FROM locomotive_lner WHERE "type" = '2-8-0' AND "lner_class" = 'o4'

Question: Which class has less in quantity than 174 between the years 1921–23?
SQL: SELECT "class" FROM locomotive_lner WHERE "quantity" < 174 AND "date" = '1921–23'

Question: Which type has a quantity of 11?
SQL: SELECT "type" FROM locomotive_lner WHERE "quantity" = 11

Question: Which class has less than 3 in quantity with  a type of 4-6-0?
SQL: SELECT "class" FROM locomotive_lner WHERE "type" = '4-6-0' AND "quantity" < 3