CREATE TABLE table_name_84 (player VARCHAR2, s_wicket VARCHAR2)

Which player has a s wicket at 48?
SELECT player FROM table_name_84 WHERE s_wicket = "48"
SELECT "player" FROM "table_name_84" WHERE "48" = "s_wicket"