CREATE TABLE table_name_74 (det_pre_amp VARCHAR2, _number_tubes VARCHAR2)

Name the det/pre-amp with # of tubes of 8
SELECT det_pre_amp FROM table_name_74 WHERE _number_tubes = "8"
SELECT "det_pre_amp" FROM "table_name_74" WHERE "8" = "_number_tubes"