CREATE TABLE sales ( sale_id INT, product_id INT, sale_region STRING, sale_amount FLOAT ) PARTITIONED BY (sale_region);SELECT person_name, product, price, years, ROW_NUMBER() OVER ( PARTITION BY years ORDER BY price) AS row_num FROM Persons;
CREATE TABLE sales ( sale_id INT, product_id INT, sale_region STRING, sale_amount FLOAT ) PARTITIONED BY (sale_region);SELECT person_name, product, price, years, ROW_NUMBER() OVER ( PARTITION BY years ORDER BY price) AS row_num FROM Persons;