RAIS growth test

gistfile1.sql

SELECT * from rais_yb y1, rais_yb y2 
WHERE y1.year + 1 = y2.year
AND y1.bra_id = y2.bra_id
AND y1.wage IS NOT NULL 
AND y2.wage_growth IS NULL 
AND y2.wage IS NOT NULL 
AND (y1.wage != 0 OR (y1.wage = 0 AND y2.wage!=0))   
LIMIT 1

SELECT * from rais_ybi y1, rais_ybi y2 
WHERE y1.year + 1 = y2.year
AND y1.bra_id = y2.bra_id
AND y1.cnae_id = y2.cnae_id
AND y1.wage IS NOT NULL 
AND y2.wage_growth IS NULL 
AND y2.wage IS NOT NULL 
AND (y1.wage != 0 OR (y1.wage = 0 AND y2.wage!=0))   
LIMIT 1

SELECT * from rais_ybio y1, rais_ybio y2 
WHERE y1.year + 1 = y2.year
AND y1.bra_id = y2.bra_id
AND y1.cnae_id = y2.cnae_id
AND y1.cbo_id = y2.cbo_id
AND y1.wage IS NOT NULL 
AND y2.wage_growth IS NULL 
AND y2.wage IS NOT NULL 
AND (y1.wage != 0 OR (y1.wage = 0 AND y2.wage!=0))   
LIMIT 1