CREATE TABLE table_203_830 (id NUMBER, "year" NUMBER, "song" CLOB, "chart positions\ us country" NUMBER, "chart positions\ can country" NUMBER, "album" CLOB)

which years saw the release of three singles ?
SELECT "year" FROM table_203_830 GROUP BY "year" HAVING COUNT("song") = 3
SELECT "year" FROM "table_203_830" GROUP BY "year" HAVING COUNT("song") = 3