select flight_id,
count(*),
sum( case is_pick when true then 1 else 0 end) 
from ticket 
group by flight_id;