When doing a select * from sales_transaction_date, there is no "count" listed so the Step.2 fails to execute.
in fact, bat_sales_daily does not exist either, but sales does exist.
SELECT , sum(count) OVER (ORDER BY sales_transaction_date) INTO bat_sales_growth FROM sales;
ERROR: column "count" does not exist
LINE 1: SELECT , sum(count) OVER (ORDER BY sales_transaction_date) ...
^
SQL state: 42703
Character: 15
When doing a select * from sales_transaction_date, there is no "count" listed so the Step.2 fails to execute. in fact, bat_sales_daily does not exist either, but sales does exist.
SELECT , sum(count) OVER (ORDER BY sales_transaction_date) INTO bat_sales_growth FROM sales; ERROR: column "count" does not exist LINE 1: SELECT , sum(count) OVER (ORDER BY sales_transaction_date) ... ^ SQL state: 42703 Character: 15
Are there steps before this?