CREATE TABLE table_name_21 (appearances NUMBER, flamengo_career VARCHAR2)

How many appearances did the flamengo player who was with flamengo during the years 1989 1993 1996 1998 2004 2005 have?
SELECT MAX(appearances) FROM table_name_21 WHERE flamengo_career = "1989–1993 1996–1998 2004–2005"
SELECT MAX("appearances") FROM "table_name_21" WHERE "1989–1993 1996–1998 2004–2005" = "flamengo_career"