CREATE TABLE table_203_843 (id DECIMAL, "record" TEXT, "date and time" TEXT, "competition" TEXT, "home or away" TEXT, "opponent" TEXT, "score" TEXT)

how many records are on the table ?
SELECT COUNT("record") FROM table_203_843
SELECT COUNT("record") FROM "table_203_843"