Page Comparison

SELECT *
FROM cognos.slxre2_pagg_sample a 
WHERE a.SAMPLE IN ('UNKNOWN_SubmittedAs_33433.wb','UNKNOWN_SubmittedAs_33514.wb')
;
SELECT a.sample_ids plated_samples, a.individual_name, a.*
FROM cognos.slxre2_pagg_sample a 
WHERE a.SAMPLE IN ('33433.wb','33514.wb')
;
-- check whether the same read group is aggregated under old and new collab sample id 
SELECT is_latest, rg.flowcell_barcode, rg.lane, rg.molecular_barcode_name, count(*),
concat_string_csv(DISTINCT a.SAMPLE )
FROM metrics.aggregation a,
metrics.aggregation_read_group rg  
WHERE a.SAMPLE IN ('UNKNOWN_SubmittedAs_33433.wb','33433.wb')
 AND a.is_latest <> 0
 AND a.id = rg.aggregation_id
GROUP BY rg.flowcell_barcode, rg.lane, rg.molecular_barcode_name, is_latest