Extra Credit $10\mathrm{.}2$: $10$ Minutes $(1$ point$)$

Create VIEW that contains

Distinct City and State Names

total # of recruiters

total, average, min, and max # of recruits

$-4.$ where city name has a term $"$or$"$

Show everything from the VIEW when City name is Portland.