CREATE TABLE table_name_48 (no_8 VARCHAR2, no_1 VARCHAR2, no_4 VARCHAR2)

Who was No. 8 when No. 1 Michael and No. 4 Logan?
SELECT no_8 FROM table_name_48 WHERE no_1 = "michael" AND no_4 = "logan"
SELECT "no_8" FROM "table_name_48" WHERE "logan" = "no_4" AND "michael" = "no_1"