Is there a way to do in a Look what the following does in SQL?
if( c in ('Anchorage','Fairbanks','Juneau'),-- that is, the c column has one of those values
) as city,
count(*) -- or another aggregate function
group by city;
This groups not by the column in the table itself but by that same column with some values combined into one.