blob: 3ddd0a3a0c3c5f224cdbae6ce546973f53d4baee [file] [log] [blame]
CREATE OR REPLACE VIEW vwOnParq_5 (col_int, col_bigint, col_char_2, col_vchar_52, col_tmstmp, col_dt, col_booln, col_dbl, col_tm) AS SELECT col_int, col_bigint, col_char_2, col_vchar_52, col_tmstmp, col_dt, col_booln, col_dbl, col_tm from `forViewCrn.parquet`;
SELECT AVG(col_int) OVER() average FROM vwOnParq_5;
DROP VIEW vwOnParq_5;