Table: lo6_stats
Columns: 1946_nos
1947_nos
date
built_at
lms_nos
br_nos

Question: Which Built at has a Date of 1946, and a 1947 Nos of 3556/7?
SQL: SELECT "built_at" FROM lo6_stats WHERE "date" = 1946 AND "1947_nos" = '3556/7'

Question: Which Date has a 1946 Nos of 3156/7?
SQL: SELECT AVG("date") FROM lo6_stats WHERE "1946_nos" = '3156/7'

Question: Which Date has a 1947 Nos of 3525-34?
SQL: SELECT COUNT("date") FROM lo6_stats WHERE "1947_nos" = '3525-34'

Question: Which 1947 Nos has a BR Nos of 48730-9?
SQL: SELECT "1947_nos" FROM lo6_stats WHERE "br_nos" = '48730-9'