CREATE TABLE table_203_580 (id NUMBER, "title" CLOB, "release" NUMBER, "genre" CLOB, "computer" CLOB, "console" CLOB, "handheld" CLOB, "smartphone" CLOB)

how many total action adventure genre games are there ?
SELECT COUNT("title") FROM table_203_580 WHERE "genre" = 'action-adventure'
SELECT COUNT("title") FROM "table_203_580" WHERE "genre" = 'action-adventure'