Crowdly

Add to Chrome

Questions Bank (1248628 total)

Napište správně:

8midenní kúra

View this question

Napište správně:

Odebíraný proud je 10mA.

View this question

Napište správně:

Ty to nevíš ?

View this question

Napište správně:

Dnes je od 14, 30 přednáška prof. Nováka.

View this question

Napište správně:

u bazénu,za plochou dráhou

View this question

Přepište správně:

Dne 23.9.1938 byla vyhlášena mobilizace .

View this question

Napište správně:

technické vybavení(hardware)

View this question

Napište správně:

30-ti denní testování

View 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:

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

Example of the order_details table:

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

Example of the customers table:

customer_id	customer_name	city
1	Laurence Lebihan	London
2	Diego Roel	Madrid

Which of the following CREATE VIEW statements would accomplish this?

CREATE VIEW order_details_view AS

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

FROM orders o

JOIN order_details d ON o.order_id = d.order_id

JOIN customers c ON o.customer_id = c.customer_id;

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;

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;

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;

View this question

What is a commit in Git?

A file in the repository

❌

A saved change to the repository

✅

A way to undo changes in the repository

❌

A branch in the repository

❌

View this question

Telegram Instagram TikTok Question Bank