SELECT ProductName, Price, SupplierName, City FROM `products` JOIN suppliers ON products.SupplierID = suppliers.SupplierID WHERE Price > 25;


SELECT ProductName, Price, SupplierName, City, Country FROM `products` JOIN suppliers ON products.SupplierID = suppliers.SupplierID ORDER BY Country;


SELECT ProductName, Price, ContactName FROM `products` JOIN suppliers ON products.SupplierID = suppliers.SupplierID WHERE Country = "Germany";

------


SELECT ProductName, Price, Unit, CategoryName FROM `products` JOIN categories ON products.CategoryID = categories.CategoryID WHERE 1;


SELECT ProductName, Price, Unit, CategoryName FROM `products` JOIN categories ON products.CategoryID = categories.CategoryID WHERE Price BETWEEN 30 AND 50;


SELECT ProductName, Price, Unit, CategoryName FROM `products` JOIN categories ON products.CategoryID = categories.CategoryID WHERE products.CategoryID IN (1,3,5,6) ORDER BY products.CategoryID;


SELECT customers.CustomerName, City, OrderDate FROM `orders` JOIN customers ON orders.CustomerID = customers.CustomerID;


SELECT customers.CustomerName, City, OrderDate FROM `orders` JOIN customers ON orders.CustomerID = customers.CustomerID WHERE OrderDate < '1996-12-25';


SELECT FirstName, LastName, CustomerID FROM `orders` JOIN employees ON orders.EmployeeID = employees.EmployeeID;


SELECT FirstName, LastName, CustomerID FROM `orders` JOIN employees ON orders.EmployeeID = employees.EmployeeID WHERE ShipperID = 1;


SELECT FirstName, LastName, CustomerID FROM `orders` JOIN employees ON orders.EmployeeID = employees.EmployeeID WHERE ShipperID = 1 ORDER BY OrderDate desc;