A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.

This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays.