What is the age of the oldest Marketing Specialist by 12/31/2015 and what is his/her hourly rate?
age as of 12/31/2015 = SUBTRACT(2015, year(BirthDate)); hourly rate refers to Rate;
SELECT 2015 - STRFTIME('%Y', T1.BirthDate), T2.Rate FROM Employee AS T1 INNER JOIN EmployeePayHistory AS T2 ON T1.BusinessEntityID = T2.BusinessEntityID WHERE T1.JobTitle = 'Marketing Specialist' ORDER BY 2015 - STRFTIME('%Y', T1.BirthDate) DESC LIMIT 1