Some sample amazon redshift code

select c.target, c.dsp  from (

SELECT placement,
(case when len(placement)-len(replace(placement,'_','')) >10
then
split_part(placement,'_',9)
 end ) as target ,

 (case when len(placement)-len(replace(placement,'_','')) >10
then
split_part(placement,'_',6)
 end ) as dsp

 from

stg.dcm_xxx_placements ) c group by c.target, c.dsp ;