Skip to content

Error: Chapter 9 Activity 18 #7

@btobin0

Description

@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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions