CREATE TABLE table_203_250 (id NUMBER, "name" CLOB, "type" CLOB, "r.a.  ( j2000 ) " CLOB, "dec.  ( j2000 ) " CLOB, "redshift  ( km/s ) " CLOB, "apparent magnitude" NUMBER)

what number of irregular types are there ?
SELECT COUNT(*) FROM table_203_250 WHERE "type" = 'irregular'
SELECT COUNT(*) FROM "table_203_250" WHERE "type" = 'irregular'