SQL LAB @ home 2

Answer-1-
select [CreditCardID] as 'Credit CardID',[CardType] as 'Credit Card Type',[CardNumber] as 'Credit Card Number',[ExpYear] as'Expiry Year' from [Sales].[CreditCard]

Answer-2-
select * from [Sales].[Customer]

Answer-3-
select [CustomerID],[AccountNumber] from [Sales].[Customer]
where [TerritoryID]=4

Answer-4-
select * from [Sales].[SalesOrderDetail]
where [UnitPrice]>2000

Answer-5-
select * from [Sales].[SalesOrderDetail]
where [ModifiedDate]='2004-06-06'

Answer-6-
select [Name] from [Production].[Product]
where [ProductID]=843

Answer-7-
select [Name],[CountryRegionCode],[SalesYTD] from [Sales].[SalesTerritory]
where [TerritoryID]= 1

Answer-8-
select * from [Sales].[SalesOrderDetail]
where [UnitPrice] between 2000 and 2100

Answer-9-
select * from [Sales].[SalesOrderHeader]
where [TaxAmt] >10000

Answer-10-
select * from [Sales].[SalesTerritory]
where [Name] in('Canada','France','Germany')