CUSTOMERSnorthwindcustomerscustomeridCompanynameCustomerIDCompanynameCityselect distinct city from customers order by cityCountryselect distinct country from customers order by countryCustomerNameContactNameCityCountry
SELECT CustomerID,Companyname AS [Customer Name],ContactName AS [Contact Name],City,Country
FROM Customers
SELECT CustomerID,Companyname AS [Customer Name],ContactName AS [Contact Name],City,Country,
customerid as Orders
FROM Customers