. Create a query in postgres that uses a Common Table Expression(CTE) and a Window Function to get the following columns:

• state_province
• last_customer_name (name of customer that placed an order mostrecently)

It should return all data from state_province andlast_customer_name

Data

DROP TABLE IF EXISTS order_line ;

DROP TABLE IF EXISTS product ;

DROP TABLE IF EXISTS order_header ;

DROP TABLE IF EXISTS customer ;

CREATE TABLE customer ( customer_id INTEGER NOT NULL,
customer_name VARCHAR (25) NOT NULL,
address_line_1 VARCHAR (200),
city VARCHAR (100),
state_province CHAR (25),
postal_code VARCHAR (50),
PRIMARY KEY (customer_id) ) ;

CREATE TABLE order_header ( order_id INTEGER NOT NULL,
order_date DATE,
customer_id INTEGER,
PRIMARY KEY (order_id),
CONSTRAINT order_fkey_customer_id FOREIGN KEY (customer_id)REFERENCES customer (customer_id)) ;

CREATE TABLE product ( product_id INTEGER NOT NULL,
product_name VARCHAR (200),
product_price MONEY,
PRIMARY KEY (product_id) ) ;

CREATE TABLE order_line ( order_id INTEGER NOT NULL,
product_id INTEGER NOT NULL,
quantity INTEGER,
PRIMARY KEY (order_id,
product_id),
CONSTRAINT order_line_fkey_order_id FOREIGN KEY (order_id)REFERENCES order_header (order_id),
CONSTRAINT order_line_fkey_product_id FOREIGN KEY (product_id)REFERENCES product (product_id)) ;