CREATE TABLE table_name_92 (segment_c VARCHAR2, segment_b VARCHAR2)

When segment B is s pineapple, what is the segment C?
SELECT segment_c FROM table_name_92 WHERE segment_b = "s pineapple"
SELECT "segment_c" FROM "table_name_92" WHERE "s pineapple" = "segment_b"