CREATE TABLE table_name_32 (artist VARCHAR2, week VARCHAR2)

Which Artist is listed as having Top 6 in Week
SELECT artist FROM table_name_32 WHERE week = "top 6"
SELECT "artist" FROM "table_name_32" WHERE "top 6" = "week"