CREATE TABLE table_name_48 (example_code__huc_ VARCHAR2, level VARCHAR2)

How many HUC example codes have 1 level?
SELECT COUNT(example_code__huc_) FROM table_name_48 WHERE level = 1
SELECT COUNT("example_code__huc_") FROM "table_name_48" WHERE "level" = 1