user: ### NOW ANSWER:
Question: Which Pick # has a League from of ontario hockey league, a Nationality of united states, and a Team from of brampton battalion?
Columns: ['Pick #', 'Player', 'Nationality', 'Position', 'Team from', 'League from']
Types: ['real', 'text', 'text', 'text', 'text', 'text']
Sample row: [31.0, 'Tyler Pitlick', 'United States', 'C', 'Minnesota State University, Mankato', 'Western Collegiate Hockey Association']
SQL:

assistant: SELECT COUNT("Pick #") FROM "Table" WHERE "League from" = 'ontario hockey league' AND "Nationality" = 'united states' AND "Team from" = 'brampton battalion';