Table: region
Columns: name
level
digits
average_size_square_miles
number_of_hus_approximate
example_name
example_code_huc

Question: What is the mean huc example code when the example name's lower snake, there are 6 digits, and less than 3 levels?
SQL: SELECT AVG("example_code_huc") FROM region WHERE "example_name" = 'lower snake' AND "digits" = 6 AND "level" < 3

Question: What's the approximate number of HUs when there are more than 2 digits, and 6 levels?
SQL: SELECT COUNT("number_of_hus_approximate") FROM region WHERE "digits" > 2 AND "level" = 6

Question: How many HUC example codes have 1 level?
SQL: SELECT COUNT("example_code_huc") FROM region WHERE "level" = 1

Question: What is the mean level number when the example name is lower snake and the approximate number is hus is less than 370?
SQL: SELECT AVG("level") FROM region WHERE "example_name" = 'lower snake' AND "number_of_hus_approximate" < 370