What's CR number that have an LMS number less 14761 and work Hawthorn Leslie 3100?
HR no. HR name CR no. LMS no. Built Works Withdrawn
Highland Railway River Class
1886270
text text real real text text text
2-1886270-1
Numbers and names
Numbers and names
70 River Ness 938 14756 9/1915 Hawthorn Leslie 3095 10/1939
71 River Spey 939 14757 9/1915 Hawthorn Leslie 3096 12/1936
(72) (River Tay) 940 14758 11/1915 Hawthorn Leslie 3097 9/1945
(73) (River Findhorn) 941 14759 11/1915 Hawthorn Leslie 3098 2/1939
(74) (River Garry) 942 14760 12/1915 Hawthorn Leslie 3099 12/1946
(75) (River Tummel) 943 14761 12/1915 Hawthorn Leslie 3100 10/1939
SELECT AVG CR no. FROM table WHERE Works = hawthorn leslie 3100 AND LMS no. < 14761
hawthorn leslie 3100 14761