Questions Bank | Page 120552

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 |

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';

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';

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 LIKE '%example_product%';

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';

View this question

Crowdly

Questions Bank (1248629 total)