blob: f98e12798c720134c4aa6d4d50b8f98aa33bcf2f [file] [log] [blame]
SELECT AVG(LEAD_c1) FROM (SELECT LEAD(c1) OVER(PARTITION BY c2 ORDER BY c1) LEAD_c1 , c2 FROM `tblWnulls.parquet`) sub_query;