Table schema:
CREATE TABLE table_name_23 (lbsc_name VARCHAR)

Question: What is the largest 1st LBSC number with a LBSC Name of northcote?
SQL: SELECT MAX(1 AS st_lbsc_no) FROM table_name_23 WHERE lbsc_name = "northcote"