CREATE TABLE table_21994729_3 (series__number NUMBER, prod_code VARCHAR2)

how many maximum series number have 2apx05 prod. code.
SELECT MAX(series__number) FROM table_21994729_3 WHERE prod_code = "2APX05"
SELECT MAX("series__number") FROM "table_21994729_3" WHERE "2APX05" = "prod_code"