CREATE TABLE table_203_2 (id DECIMAL, "name" TEXT, "mineral" TEXT, "opened" TEXT, "closed" TEXT, "years connected" TEXT, "notes" TEXT)

how many quarries was slate mined at ?
SELECT COUNT(*) FROM table_203_2 WHERE "mineral" = 'slate'
SELECT COUNT(*) FROM "table_203_2" WHERE "mineral" = 'slate'