1-- Find all brigades an user is assigned to 2select bm.brigade_id 3from public.brigade_membership as bm 4where bm.user_id = $1;