SQL. Calc the sum with case, example

select 
  sum(case town_to
    when 'LosAngeles' then 1 else 0
  end)
from trip;