CREATE TABLE table_204_398 (id NUMBER, "title" CLOB, "year" NUMBER, "publisher" CLOB, "developer" CLOB, "platforms" CLOB)

total number of middle earth video games published by melbourne house
SELECT COUNT("title") FROM table_204_398 WHERE "publisher" = 'melbourne house'
SELECT COUNT("title") FROM "table_204_398" WHERE "publisher" = 'melbourne house'