2. Display the ID, type, number, and expiry year of all the credit cards in the following format. (Use the AdventureWorks database)

select * from Sales.CreditCard
select 'CreditCardID'=CreditCardID,
'card Type'=CardType,
'CardNumber'=CardNumber,
'Expyear'= Expyear from sales.CreditCard