CREATE TABLE table_203_696 (id DECIMAL, "year" DECIMAL, "single" TEXT, "charts\ fr" DECIMAL, "charts\ bel\ wa" DECIMAL, "charts\ swi" DECIMAL, "certification" DECIMAL, "album" TEXT)

how many singles were released before 2001 but after 1997 ?
SELECT COUNT("single") FROM table_203_696 WHERE "year" < 2001 AND "year" > 1997
SELECT COUNT("single") FROM "table_203_696" WHERE "year" < 2001 AND "year" > 1997