Suppose you have a PostgreSQL database that contains three tables, orders , order_details and customers . The orders table contains basic information about each order, including the order ID and customer ID, customers table contains information about customer, while the order_details table contains the details of each order, including the product ID, quantity, and price. You want to create a view that shows the order ID, customer name, product name, quantity, and price for all orders.

Example of the orders table:

Example of the order_details table:

Example of the customers table:

Which of the following CREATE VIEW statements would accomplish this?

Question

Suppose you have a PostgreSQL database that contains three tables,  orders ,  order_details  and  customers . The  orders  table contains basic information about each order, including the order ID and customer ID,   customers  table contains information about customer, while the  order_details  table contains the details of each order, including the product ID, quantity, and price. You want to create a view that shows the order ID, customer name, product name, quantity, and price for all orders.

Example of the  orders  table: 
                                          
                                         Example of the  order_details  table:

Example of the  customers  table:

Which of the following CREATE VIEW statements would accomplish this?

Accepted Answer

CREATE VIEW order_details_view AS

SELECT o.order_id, c.customer_name, d.product_name, d.quantity, d.price

FROM orders o, order_details d, customers c

WHERE o.order_id = d.order_id

AND o.customer_id = c.customer_id;

✅

Accepted Answer

CREATE VIEW order_details_view AS

SELECT o.order_id, c.customer_name, d.product_name, d.quantity, d.price

FROM orders o, order_details d, customers c

WHERE o.order_id = d.order_id

AND o.customer_id = c.customer_id;

✅

Accepted Answer

CREATE VIEW order_details_view AS

SELECT order_id, customer_name, product_name, quantity, price

FROM orders

JOIN order_details ON orders.order_id = order_details.order_id

JOIN customers ON orders.customer_id = customers.customer_id;

✅

Accepted Answer

CREATE VIEW order_details_view AS

SELECT order_id, customer_name, product_name, quantity, price

FROM orders

INNER JOIN order_details ON orders.order_id = order_details.order_id

INNER JOIN customers ON orders.customer_id = customers.customer_id;

✅

order_id	customer_id	order_date
1	1	2022-03-01
2	2	2022-03-02
3	1	2022-03-03
4	3	2022-03-04

order_id	product_id	quantity	price
1	1	3	10.00
2	2	5	15.00
1	3	2	20.00
4	1	1	8.50

customer_id	customer_name	city
1	Laurence Lebihan	London
2	Diego Roel	Madrid

Crowdly

Suppose you have a PostgreSQL database that contains three tables, orders , o...

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