WEB API,REST WEB SERVICES

Hi , I have an SQL Server View called offers I have airportcode, a string value in that view,I need to create a rest webservice to retrieve all offers in airports

say example, http://localhost/api/offers/kwi I am very new to this area, Please help me to sort this, I know this is very simple