CREATE TABLE table_name_47 (icb_sector VARCHAR, ticker_symbol VARCHAR)

Which ICB Sector had a ticker symbol of pp?
SELECT icb_sector FROM table_name_47 WHERE ticker_symbol = "pp"
SELECT "icb_sector" FROM "table_name_47" WHERE "pp" = "ticker_symbol"