Error: Chapter 9 Activity 18

[btobin0]

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?