--Dinh Tuan Anh - ANHDTHE141302 --NortWind-ex USE Northwind GO --ex1. SELECT LOWER(FirstName + ' ' + LastName) AS FullName , TitleOfCourtesy FROM Employees GO --ex2. SELECT UPPER(FirstName + ' ' + LastName) AS FullName FROM Employees GO --ex3. SELECT Employees.EmployeeID , Employees.LastName , Employees.FirstName , Employees.Title , Employees.City , Employees.Country FROM dbo.Employees WHERE Employees.Country = 'USA' GO --ex4. SELECT Customers.CustomerID , Customers.CompanyName , Customers.ContactName , Customers.ContactTitle , Customers.Country FROM Customers WHERE Customers.Country = 'UK' GO --Ex5. SELECT Customers.CustomerID , Customers.CompanyName , Customers.Address , Customers.City , Customers.Country FROM dbo.Customers WHERE Customers.Country = 'Mexico' GO --Ex6. SELECT Customers.CustomerID , Customers.CompanyName , Customers.Phone , Customers.Address , Customers.City , Customers.Country FROM dbo.Customers WHERE Customers.Country = 'Sweden' GO --Ex7. SELECT Products.ProductID , Products.ProductName , Products.UnitPrice , Products.UnitsInStock FROM dbo.Products WHERE Products.UnitsInStock BETWEEN 5 AND 10 GO --Ex8. SELECT Products.ProductID, Products.ProductName, Products.UnitPrice, Products.ReorderLevel, Products.UnitsOnOrder FROM dbo.Products WHERE Products.UnitsOnOrder BETWEEN 60 AND 100 GO