CREATE TABLE table_name_23 (cr_no INT, works VARCHAR, lms_no VARCHAR)

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