CREATE TABLE table_23117 ("Fleet #" CLOB, "Year" FLOAT, "Manufacture" CLOB, "Model" CLOB, "Length  ( ft ) " FLOAT, "Engine" CLOB, "Transmission" CLOB)

What year had an Allison B400R transmission and a model of BRT?
SELECT "Year" FROM table_23117 WHERE "Transmission" = 'Allison B400R' AND "Model" = 'BRT'
SELECT "Year" FROM "table_23117" WHERE "Model" = 'BRT' AND "Transmission" = 'Allison B400R'