CREATE TABLE table_name_88 (Id VARCHAR2)

Name the 2008 with 1998 of a and 2002 of 1r with 2004 of 2r
SELECT 2008 FROM table_name_88 WHERE 1998 = "a" AND 2002 = "1r" AND 2004 = "2r"
SELECT 2008 FROM "table_name_88" WHERE "1r" = 2002 AND "2r" = 2004 AND "a" = 1998