Suppose you have two tables in a PostgreSQL database, orders and products . You want to create a view that shows the order ID, product name, and quantity for all orders that include a particular product. Which of the following CREATE VIEW statements would accomplish this?

Table Example:
orders table:
| order_id | product_id | quantity | |----------|------------|----------| | 1 | 1 | 3 | | 2 | 2 | 5 | | 3 | 1 | 2 | | 4 | 3 | 1 | products table:
| id | product_name | |----|--------------| | 1 | Widget A | | 2 | Widget B | | 3 | Widget C |

Question

Suppose you have two tables in a PostgreSQL database,  orders  and  products . You want to create a view that shows the order ID, product name, and quantity for all orders that include a particular product. Which of the following CREATE VIEW statements would accomplish this? 
 
 Table Example: 
 orders  table: 
 | order_id | product_id | quantity | |----------|------------|----------| | 1        | 1          | 3        | | 2        | 2          | 5        | | 3        | 1          | 2        | | 4        | 3          | 1        | products  table: 
 | id | product_name | |----|--------------| | 1  | Widget A     | | 2  | Widget B     | | 3  | Widget C     |

Accepted Answer

CREATE VIEW order_product AS SELECT order_id, product_name, quantity FROM orders JOIN products ON orders.product_id = products.id WHERE product_name = 'example_product';

Accepted Answer

CREATE VIEW order_product AS SELECT orders.order_id, products.product_name, orders.quantity FROM orders, products WHERE orders.product_id = products.id AND products.product_name = 'example_product';

Accepted Answer

CREATE VIEW order_product AS

SELECT orders.order_id, products.product_name, orders.quantity

FROM orders, products

WHERE orders.product_id = products.id

AND products.product_name = 'example_product';

✅

Answer

CREATE VIEW order_product AS SELECT order_id, product_name, quantity FROM orders JOIN products ON orders.product_id = products.id HAVING product_name = 'example_product';

Crowdly

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

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