CREATE TABLE table_79855 ("Title" CLOB, "Producer ( s ) " CLOB, "Artist ( s ) " CLOB, "Time" CLOB, "Team ( s ) " CLOB)

Who is the artist of the New York Giants track 'No Doubt'?
SELECT "Artist(s)" FROM table_79855 WHERE "Team(s)" = 'new york giants' AND "Title" = 'no doubt'
SELECT "Artist(s)" FROM "table_79855" WHERE "Team(s)" = 'new york giants' AND "Title" = 'no doubt'