create table sample_data ( 
	group1 number(6), 
	group2 varchar2(8), 
	expected_master_group2 varchar2(8)	 
)

insert into sample_data values(129653, '4190414', '4190412')

insert into sample_data values(129653, '4190414', '4190412')

insert into sample_data values(129654, '4190413', '4190412')

insert into sample_data values(129654, '4190414', '4190412')

insert into sample_data values(129655, '4190409', '4188693')

insert into sample_data values(129655, '4190409', '4188693')

insert into sample_data values(129656, '4188693', '4188693')

insert into sample_data values(129656, '4188693', '4188693')

insert into sample_data values(129657, '4190409', '4188693')

insert into sample_data values(129657, '4190409', '4188693')

insert into sample_data values(129657, '4190409', '4188693')

insert into sample_data values(129658, '4190409', '4188693')

insert into sample_data values(129658, '4190409', '4188693')

insert into sample_data values(129659, '4190409', '4188693')

insert into sample_data values(129659, '4190409', '4188693')

insert into sample_data values(129660, '4190409', '4188693')

insert into sample_data values(129660, '4190409', '4188693')

insert into sample_data values(129668, '4190412', '4190412')

insert into sample_data values(129668, '4190412', '4190412')

insert into sample_data values(129669, '4190412', '4190412')

insert into sample_data values(129669, '4190413', '4190412')

insert into sample_data values(129670, '4190412', '4190412')

insert into sample_data values(129670, '4190412', '4190412')

insert into sample_data values(129671, '4188693', '4188693')

insert into sample_data values(129671, '4188693', '4188693')

insert into sample_data values(129671, '4188693', '4188693')

insert into sample_data values(129671, '4188693', '4188693')

insert into sample_data values(129671, '4190410', '4188693')

insert into sample_data values(129672, '4190409', '4188693')

insert into sample_data values(129673, '4188693', '4188693')

insert into sample_data values(129673, '4190409', '4188693')

insert into sample_data values(129674, '4190409', '4188693')

insert into sample_data values(129675, '4190409', '4188693')

insert into sample_data values(129675, '4190409', '4188693')

insert into sample_data values(129675, '4190409', '4188693')

insert into sample_data values(129676, '4188693', '4188693')

insert into sample_data values(129676, '4188693', '4188693')

insert into sample_data values(129677, '4190410', '4188693')

insert into sample_data values(129678, '4190409', '4188693')

insert into sample_data values(129678, '4190409', '4188693')

insert into sample_data values(129678, '4190409', '4188693')

insert into sample_data values(129679, '11219712', '11219712')

insert into sample_data values(129679, '11219712', '11219712')

insert into sample_data values(129679, '11219712', '11219712')