Suppose you have two tables in a PostgreSQL database, customers and orders , with the following data:
customers table: orders table: Which of the following CREATE VIEW statements would create a vertical view that displays the customer name, order ID, and total amount for all orders?

Question

Suppose you have two tables in a PostgreSQL database,  customers  and  orders , with the following data: 
 customers  table:  orders  table:  Which of the following CREATE VIEW statements would create a vertical view that displays the customer name, order ID, and total amount for all orders?

Accepted Answer

CREATE VIEW customer_orders_view AS SELECT c.customer_name, o.order_id, o.total_amount FROM customers c JOIN orders o ON c.customer_id = o.customer_id;

Answer

CREATE VIEW customer_orders_view AS SELECT customer_name, order_id, total_amount FROM customers, orders WHERE customers.customer_id = orders.customer_id GROUP BY customers.customer_id;

Answer

CREATE VIEW customer_orders_view AS SELECT customer_name, order_id, total_amount FROM customers LEFT JOIN orders ON customers.customer_id = orders.customer_id;

Answer

CREATE VIEW customer_orders_view AS SELECT c.customer_name, o.order_id, o.total_amount FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id;

customer_id	customer_name	address	city
1	John Smith	123 Main St.	Anytown
2	Jane Doe	456 Oak St.	Other town
3	Bob Johnson	789 Maple Ave.	Another town

order_id	customer_id	order_date	total_amount
1	1	2022-03-01	150.00
2	2	2022-03-02	75.00
3	1	2022-03-03	25.00
4	3	2022-03-04	50.00

Crowdly

Suppose you have two tables in a PostgreSQL database, customers and orders ,...

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