Page Comparison

(
SELECT source, appccc_id,max(value)  as   hs_name, hs_city, hs_state
FROMedu_level
  FROM apply__application_vw ca
LEFT JOIN apply__education_vw cae
PIVOT  (  ON (ca.app_id  max(value= cae.app_id)
FORWHERE fieldca.source IN= ('hsstnd_name','hs_city', 'hs_state')
 ))application' 
   AND cae.field = 'hs_edu_level' 
   and ca.tstmp_create > '2025-01-01' group by source, appccc_id;