framework/resources/Functional/union/union_36.sql

SELECT c1, c2, c3, c4, c5, c6, c7, c8, c9 FROM `union_01.parquet` WHERE c3 NOT in ('WI') UNION SELECT c1, c2, c3, c4, c5, c6, c7, c8, c9 FROM `union_02.parquet` WHERE c3 = 'WI';