CREATE TABLE table_name_7 (lb VARCHAR2, scr_no VARCHAR2, sr_no VARCHAR2)

Name the LB&SCR number that has SR number of 8597 8600
SELECT lb & scr_no FROM table_name_7 WHERE sr_no = "8597–8600"
SELECT "lb" & "scr_no" FROM "table_name_7" WHERE "8597–8600" = "sr_no"