Posted by 
Tables
Table 1: Suppliers
|
SupplierID |
SupplierName |
ContactName |
Address |
City |
PostalCode |
Country |
Phone |
|
10 |
Refrescos Americanas LTDA |
Carlos Diaz |
Av. das Americanas 12.890 |
São Paulo |
5442 |
Brazil |
(11) 555 4640 |
|
21 |
Lyngbysild |
Niels Petersen |
Lyngbysild Fiskebakken 10 |
Lyngby |
2800 |
Denmark |
43844108 |
|
22 |
Zaanse Snoepfabriek |
Dirk Luchte |
Verkoop Rijnweg 22 |
Zaandam |
9999 ZZ |
Netherlands |
(12345) 1212 |
Table 2: Products
|
ProductID |
ProductName |
SupplierID |
CategoryID |
Unit |
Price |
|
24 |
Guaraná Fantástica |
10 |
1 |
12 – 355 ml cans |
4.5 |
|
45 |
Røgede sild |
21 |
8 |
1k pkg. |
9.5 |
|
46 |
Spegesild |
21 |
8 |
4 – 450 g glasses |
12 |
|
47 |
Zaanse koeken |
22 |
3 |
10 – 4 oz boxes |
9.5 |
|
48 |
Chocolade |
22 |
3 |
10 pkgs. |
12.75 |
Query
If you need a place to try this query, try here: https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in
SELECT SupplierName
FROM Suppliers
WHERE NOT EXISTS (
SELECT ProductName
FROM Products
WHERE SupplierId = Suppliers.supplierId
AND Price > 13
);
Result
|
SupplierName |
|
Refrescos Americanas LTDA |
|
Lyngbysild |
|
Zaanse Snoepfabriek |
© 2019, Alejandro G. Carlstein Ramos Mejia. All rights reserved.
