Suppose you have a PostgreSQL database that contains a table named sales , which contains information about sales transactions. The sales table has columns for the date of the transaction, the name of the salesperson, the product sold, and the amount of the sale. You want to create a grouped view that shows the total sales amount for each salesperson and product combination.
Example of the sales table: Which of the following CREATE VIEW statements would accomplish this?

Question

Suppose you have a PostgreSQL database that contains a table named  sales , which contains information about sales transactions. The  sales  table has columns for the date of the transaction, the name of the salesperson, the product sold, and the amount of the sale. You want to create a grouped view that shows the total sales amount for each salesperson and product combination. 
 Example of the  sales  table:  Which of the following CREATE VIEW statements would accomplish this?

Accepted Answer

CREATE VIEW sales_view AS SELECT salesperson, product, SUM(sale_amount) AS total_sales FROM sales GROUP BY salesperson, product;

Answer

CREATE VIEW sales_view AS SELECT salesperson, product, MAX(sale_amount) AS total_sales FROM sales GROUP BY salesperson, product;

Answer

CREATE VIEW sales_view AS SELECT salesperson, product, AVG(sale_amount) AS total_sales FROM sales GROUP BY salesperson, product;

Answer

CREATE VIEW sales_view AS SELECT salesperson, product, sale_amount FROM sales GROUP BY salesperson, product;

sale_date	salesperson	product	sale_amount
2022-03-01	John Smith	Product A	100.00
2022-03-01	Jane Doe	Product B	75.00
2022-03-02	John Smith	Product C	50.00
2022-03-03	Bob Johnson	Product A	25.00
2022-03-03	Jane Doe	Product B	150.00

Crowdly

Suppose you have a PostgreSQL database that contains a table named sales , whi...

Want instant access to all verified answers on softserve.academy?