Table: southern_rail_locomotives
Columns: iwcr_no
name
wheel_arrangement
sr_no
year_made
year_withdrawn

Question: Which of the lowest years had a Wheel arrangement that was 0-4-2t?
SQL: SELECT MIN("year_made") FROM southern_rail_locomotives WHERE "wheel_arrangement" = '0-4-2t'

Question: What is the mean Year when the IWCR number was 5 and the Year withdrawn was bigger than 1926?
SQL: SELECT AVG("year_made") FROM southern_rail_locomotives WHERE "iwcr_no" = '5' AND "year_withdrawn" > 1926

Question: Which SR number had a wheel arrangement of 0-6-0t, the year made was more recent than 1874, and the year withdrawn was 1963?
SQL: SELECT "sr_no" FROM southern_rail_locomotives WHERE "wheel_arrangement" = '0-6-0t' AND "year_made" > 1874 AND "year_withdrawn" = 1963

Question: What is the sum number of years where the wheel arrangement of 0-4-0t?
SQL: SELECT COUNT("year_made") FROM southern_rail_locomotives WHERE "wheel_arrangement" = '0-4-0t'