select *from Customers where Country='Switzerland'
-------------------- CAU 8
SELECT Customers.CustomerID, Customers.CompanyName, Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE (Customers.Address LIKE 'Ru%')
------------------------ CAU 9
SELECT Customers.CompanyName, OrderDetails.OrderID, Orders.OrderDate, OrderDetails.ProductID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID ORDER BY ProductID
------------------- CAU 10
SELECT Customers.CustomerID, COUNT (OrderDetails.OrderID) as SoHoaDon,sum (UnitPrice * Quantity) as TongTien FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID
group by Customers.CustomerID
-------------------- CAU 11
SELECT Customers.CustomerID, COUNT (OrderDetails.OrderID) as SoHoaDon,sum (UnitPrice * Quantity) as TongTien FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID
group by Customers.CustomerID having sum (UnitPrice * Quantity)>700000000
--------------------- CAU 12
SELECT CustomerID,CompanyName,[Address],Country,Phone from Customers
WHERE CustomerID not in (select CustomerID from Orders)