I want to convert following code into bigquery

Question

SELECT shipment_id,
    CASE
    WHEN SUM(qty) FILTER (WHERE facility = 'SLCW' AND address SIMILAR TO '(N|Q|R|0|Y|Z)%') > '0' 
           AND SUM(qty) FILTER (WHERE facility = 'SLCW' AND address NOT SIMILAR TO '(N|Q|R|0|Y|Z)%') IS NULL)
           OR (SUM(qty) FILTER (WHERE facility = 'CVDC' AND address SIMILAR TO '(1|2|3|4|5|6|7|8|9)%') > '0'
           AND SUM(qty) FILTER (WHERE facility = 'CVDC' AND address NOT SIMILAR TO '(1|2|3|4|5|6|7|8|9)%') IS NULL) THEN 'noncon'
    WHEN ((SUM(qty) FILTER (WHERE facility = 'SLCW' AND address SIMILAR TO '(M)%') > '0'
           OR SUM(qty) FILTER (WHERE facility = 'CVDC' AND address SIMILAR TO '(0)%') > '0')
           OR ((SUM(qty) FILTER (WHERE facility = 'SLCW' AND address SIMILAR TO '(M|N|Q|R|0|Y|Z)%') > '0' 
           AND SUM(qty) FILTER (WHERE facility = 'SLCW' AND address NOT SIMILAR TO '(M|N|Q|R|0|Y|Z)%') > '0')
           OR (SUM(qty) FILTER (WHERE facility = 'CVDC' AND address SIMILAR TO '(0|1|2|3|4|5|6|7|8|9)%') > '0' 
           AND SUM(qty) FILTER (WHERE facility = 'CVDC' AND address NOT SIMILAR TO '(0|1|2|3|4|5|6|7|8|9)%') > '0'))) THEN 'marryup'
    ELSE 'conveyable' END AS st_one
     FROM needed_picks