SQL для тестировщика

Даны следующие таблицы:

Customers

| CustomerID |   Name   |   City   |
|------------|----------|----------|
|     1      |   John   |  London  |
|     2      |   Jane   |  Paris   |
|     3      |   Mark   |  London  |
|     4      |   Sarah  |  Berlin  |
|     5      |  Michael |  Madrid  |

Orders

| OrderID | CustomerID |   Product   |
|---------|------------|-------------|
|   1001  |     1      |   Laptop    |
|   1002  |     2      |   Phone     |
|   1003  |     1      |   Tablet    |
|   1004  |     4      |   Camera    |
|   1005  |     3      |   TV        |

Какой из следующих SQL запросов отберет имена покупателей, которые разместили заказы на продукт с названием "Laptop"?

A)

SELECT Name FROM Customers WHERE Product = 'Laptop'

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Product = 'Laptop'

SELECT Name FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Product = 'Laptop'

D) SELECT Name FROM Customers WHERE Product = 'Laptop' JOIN Orders ON Customers.CustomerID = Orders.CustomerID

www.tg-me.com/us/SQL для тестировщика/com.sql_for_qa/159

1.6K viewsAug 11, 2023 at 06:02

tg-me.com/sql_for_qa/159

Create: 2023-08-11
Last Update: 2025-07-01 18:56:01

Даны следующие таблицы:

Customers

| CustomerID |   Name   |   City   |
|------------|----------|----------|
|     1      |   John   |  London  |
|     2      |   Jane   |  Paris   |
|     3      |   Mark   |  London  |
|     4      |   Sarah  |  Berlin  |
|     5      |  Michael |  Madrid  |

Orders

| OrderID | CustomerID |   Product   |
|---------|------------|-------------|
|   1001  |     1      |   Laptop    |
|   1002  |     2      |   Phone     |
|   1003  |     1      |   Tablet    |
|   1004  |     4      |   Camera    |
|   1005  |     3      |   TV        |

SELECT Name FROM Customers WHERE Product = 'Laptop'

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Product = 'Laptop'

SELECT Name FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Product = 'Laptop'

D) SELECT Name FROM Customers WHERE Product = 'Laptop' JOIN Orders ON Customers.CustomerID = Orders.CustomerID

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/159

SQL для тестировщика Telegram | DID YOU KNOW?