blob: dfe8a2cf132726bfaf52bfffbbbdb55f40cd98ad [file] [log] [blame]
SELECT AVG(lead_col0) FROM (SELECT LEAD(col0) OVER(PARTITION BY col7 ORDER BY col0) lead_col0 , col7 FROM `allTypsUniq.parquet`) sub_query;