CREATE TABLE Customers_cards (card_type_code VARCHAR2)

How many debit cards do we have?
SELECT COUNT(*) FROM Customers_cards WHERE card_type_code = "Debit"
SELECT COUNT(*) FROM "Customers_cards" WHERE "Debit" = "card_type_code"