user: ### NOW ANSWER:
Question: Which Artist is listed as having Top 6 in Week
Columns: ['Week', 'Theme', 'Song Sung', 'Artist', 'Status']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Top 24', 'Semifinals Top 12 (Men)', '"You Are My Lady"', 'Freddie Jackson', 'Advanced']
SQL:

assistant: SELECT "Artist" FROM "Table" WHERE "Week" = 'Top 6';