--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