Table: river_class_info_2
Columns: hr_no
hr_name
cr_no
lms_no
built
works
withdrawn

Question: What's the HR number when the LMS number is 14758?
SQL: SELECT "hr_no" FROM river_class_info_2 WHERE "lms_no" = 14758

Question: What's the CR number that has an LMS number less than 14761 and works of Hawthorn Leslie 3100?
SQL: SELECT AVG("cr_no") FROM river_class_info_2 WHERE "works" = 'hawthorn leslie 3100' AND "lms_no" < 14761

Question: What's the HR Number when the LMS number is 14757 and has a built of 9/1915?
SQL: SELECT "hr_no" FROM river_class_info_2 WHERE "built" = '9/1915' AND "lms_no" = 14757

Question: What's the built date when the CR number is more than 940 and the LMS number is 14760?
SQL: SELECT "built" FROM river_class_info_2 WHERE "cr_no" > 940 AND "lms_no" = 14760